If you are running in pick flavor then you will need to use "eval". If
you create an entry in the VOC like this (which is the IDEAL flavor
version of LIST)-
LIST2
0001 V
0002 LIST
0003 Q
0004 GHS
Then you can do
LIST2 VOC WITH F2 LIKE '..."...'
Or
LIST2 VOC WITH F2 LIKE '0X"0X'
Hope that helps....
Rod Hills
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko
Sent: Wednesday, October 26, 2005 2:09 PM
To: [email protected]
Subject: [U2] [UD] how to find records with a " in the data
We have a number of records with double-quote (") characters in one of
the
data fields. We'd like to be able to select those records so we can fix
up
the data. Is there any way to find these records with a SELECT
statement? I've tried:
SELECT filename WITH fieldname LIKE '..."...' which gives a "missing
quote" error
and
SELECT filename WITH fieldname LIKE ..."... which returns all the
records
in the file
ESEARCH does work, but we thought we should be able to do this somehow
with
SELECT.
Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED] 765-361-6440
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
