You could also do the record level search with the following EVAL...

LIST filename WITH EVAL "INDEX(@RECORD,CHAR(34),1)" GT 0

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko
Sent: Friday, October 28, 2005 9:00 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] how to find records with a " in the data -
solution

Thanks to someone whose message I deleted, I now know that (in Unidata,
at 
least), there are two ways to do this:

:ESEARCH filename
     STRING : "

will get you all the records that have a double quote anywhere in the
record.

:SELECT filename WITH EVAL 'COUNT(fieldname,CHAR(34))' GE 1

will get you all the records with a double quote in the field you're 
interested in.


At 02:20 PM 10/27/05, you wrote:
>Please post; I would like this information too.
>-Keith Johnson
>LCSC.

Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED]     765-361-6440 
-------
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/

Reply via email to