If you want to check every field.
SEARCH FILENAME
prompts STRING: and you enter "
Which will return a select list for any record containing a ". And
then you can pass that list to the editor to clean it up.
Roger
Kathy Tymoczko wrote:
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
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/