HP3000-L Archives

September 1998, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Query Variable use in search and replace
From:
John Zoltak <[log in to unmask]>
Reply To:
John Zoltak <[log in to unmask]>
Date:
Fri, 11 Sep 1998 13:17:50 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (101 lines) 
Absolutely, but I just left out some of the details figuring they were
obvious!

John Zoltak
North American Mfg Co

> -----Original Message-----
> From: Leonard Berkowitz [SMTP:[log in to unmask]]
> Sent: Friday, September 11, 1998 1:11 PM
> To:   John Zoltak
> Subject:      Re: [HP3000-L] Query Variable use in search and replace
>
> John's technique is a good one, but won't  you need a covering file
> equation to route QSLIST to a disk file?
>
>
> ========================
> Leonard S. Berkowitz
> mailto:[log in to unmask]
> phone: (617) 972-9400 ext. 3250
> fax:   (617) 923-5555
>
>
>
>
>
>
>
>
> John Zoltak <[log in to unmask]> on 09/11/98 12:59:01 PM
>
> Please respond to John Zoltak <[log in to unmask]>
>
> To:   [log in to unmask]
> cc:    (bcc: Leonard Berkowitz/THP)
> Subject:  Re: [HP3000-L] Query Variable use in search and replace
>
>
>
>
> Mark,
>
> A technique that I use in QUERY (when I'm not in the mood to write yet
> another program for something that's supposed to be a one-time thing)
> is
> to report the values to a file in such a way that the file can be
> XEQ'd
> from Query to replace the values after using QUAD to replace the "UFD"
> with "uF". For example
>
> OUT=LP
> R
> D1,"F KEY=",6; D1,KEY-ITEM,12 (assuming key is 6 chars long)
> D2,"REPL,DATA-ITEM=""",16; D2,DATA-ITEM,26; (assuming data-item is 10
> chars) D2,"""";END",31
> NOPAGE;END
> OUT=TERM
>
> use quad or whatever to change the values then
>
> XEQ TheFile
>
> Note also that this only works when you can uniquely identify the
> target
> record. Anyway, you get the idea. I've done many variations on this.
>
> Hope this helps
> John Zoltak
> North American Mfg Co
>
>
> > -----Original Message-----
> > From: Mark Gross [SMTP:[log in to unmask]]
> > Sent: Friday, September 11, 1998 10:38 AM
> > To:   [log in to unmask]
> > Subject:      [HP3000-L] Query Variable use in search and replace
> >
> > maybe I'm using the wrong tool here, but has anyone found a way
> using
> > Query
> > to replace a image field value
> > that requires use of a variable? The following example shows what I
> > want to
> > do.
> >
> > 1. find all occurrences of the substring "UFD" in the 60 character
> > field
> > EXTDESC
> > 2. change "UFD" to "uF"
> >
> >
> >
> > Mark Gross
> > Emerson Motion Control
> > [log in to unmask]
>
>
>
>
>

ATOM RSS1 RSS2