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
----Original Message----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson
Sent: Thursday, October 27, 2005 12:21 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] how to find records with a " in the data
> Please post; I would like this information too.
> -Keith Johnson
> LCSC.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Kathy Tymoczko
> Sent: Wednesday, October 26, 2005 2:09 PM
> To: u2-users@listserver.u2ug.org
> 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
> 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/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
