Sorry, I didn't actually construct matching data to check it. :)
I see you are right. I tried using:
select filename WITH fieldname = '..."...'
but the ellipses, which cause it to do pattern matching, apparently also
cause it to look for an included string enclosed by ", with no way to
include an actual " in the string (ie, by doubling or trippling it, or
enclosing withing another delimiter like \"\). So it looks like ESEARCH, an
i-desc or a basic program are the only answers.
-Keith
----Original Message----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 8:26 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] how to find records with a " in the data
> If by worked you mean the statement didn't give you any
> syntax errors.
>
> When using the u-type parser the syntax for the select is different.
> This won't find a field with a double quote in it, it will find one
> where the field IS actually ["].
>
> Hth
> Colin Alfke
>
>> -----Original Message-----
>> From: Keith W. Roberts
>>
>> I posted earlier than in UD the following doesn't work (you get a
>> syntax error):
>>
>> SELECT filename WITH fieldname = '["]'
>>
>> but it turns out that wasn't quite accurate. 'Tis true when
>> ECLTYPE='p', which is our setting, so I tried:
>>
>> select filename WITH fieldname = '["]'
>>
>> which worked. Notice that "select" is in lowercase, which I
>> believe reverses the ECLTYPE, making it 'u'.
>>
>> -Keith
> -------
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
