Wonderful:-)
Thanks Doug. I had tried every combination I could think of like this,
Triple quotes, Double quote within Single quotes. But not Double Double
Quotes. Worked a treat and will save a customer a very tedious task.
Again Many Thanks
Alan
In message <[log in to unmask]>, Doug Werth
<[log in to unmask]> writes
>Alan,
>
>Use double quote marks to substitute the quote mark into the string.
>Continue to put quote marks around the entire string. This will look kind of
>strange because you want an quote mark at the end of your string so you will
>actually have three quotation marks - two of them to indicate a quote mark
>and one as a delimiter.
>
> REPL ITEM2="STARTTEXT,Find ""K<00000,0>"""
>
>Doug.
>
>Doug Werth Beechglen Development Inc.
>[log in to unmask] Cincinnati, Ohio
>
>----- 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 *
|
