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 17:25:18 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (86 lines) 
Mark,

Yes, Query should not upshift your input.

John Zoltak
North American Mfg Co

> -----Original Message-----
> From: Mark Gross [SMTP:[log in to unmask]]
> Sent: Friday, September 11, 1998 5:11 PM
> To:   [log in to unmask]
> Subject:      Re: [HP3000-L] Query Variable use in search and replace
>
> Can Query handle lower case? Seems to me it converts everything to
> upper
> case when trying a REPL command.
>
> Mark
>
> ----------
> > From: John Zoltak <[log in to unmask]>
> > To: 'Mark Gross' <[log in to unmask]>; 'HP3000-L'
> <[log in to unmask]>
> > Subject: RE: [HP3000-L] Query Variable use in search and replace
> > Date: Friday, September 11, 1998 11:59 AM
> >
> > 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