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/