The only way I  know of to do this without writing a program is to use the
following report edit logic.
Hope it helps,
Mike

<<backup database>>

build outfile;rec=-80,,f,ascii;disc=1000000
file qslist=outfile,old;dev=disc
query
out=lp
<<open db and find records>>
REPORT ALL,X
delete

exit
<< use editor, qedit, quad to modify outfile records and add 'add set name'
as first record and // as last record >>

query
<open db for write access>>
x outfile
exit

----- Original Message -----
From: "Alan Yeo" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Wednesday, May 23, 2001 3:16 AM
Subject: [HP3000-L] Using Quotes in a Query Replace


> Hi folks
>
> I wonder if there is a Query expert out there that can help me.
>
> I want to find an X type item that contains a particular string that
> includes several " characters and replace the string with another string
> that also contains the " character.
>
> I can find the correct items OK using MATCH where the ? stands in for
> the "
>
> FIND ITEM1=?????????????????????
> 123456 RECORDS FOUND
> SUBSET ITEM2 M "STARTTEXT?aaaab?K?99999?*"
> 46 RECORDS FOUND
>
> But when I do the REPLACE how can I specify the " character several
> times?
>
> REPL ITEM2='STARTTEXT,Find "K<00000,0>"'
>
> Where the ' should be the " Query expects, and " is the " I want in the
> string.
>
> Any help greatly appreciated. I know I could write a program, but this
> was supposed to be a quick and dirty, which has now probably taken
> longer than writing a program. But I'm darned if I'll let it beat me now
> :-)
>
> Regards
> Alan
>
> Alan Yeo
> [log in to unmask]    Just because you're paranoid
> Phone +44 1684 291710   it doesn't mean someone isn't!.
> Fax   +44 1684 291712
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *