Doesn't work in UD. Don't know whether that's a bug or a limitation, though.
Try an I-desc with F2 like: IF fieldname MATCHES "0X'":CHAR(32):"'0X" THEN 1 ELSE '' Then you can: SELECT filename WITH idesc -Keith ----Original Message---- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Wednesday, October 26, 2005 2:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] how to find records with a " in the data > Try...just a guess. > > select filename with fieldname like '...\"\...' > > it works with UV basic > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] Behalf Of Kathy >> Tymoczko Sent: Wednesday, October 26, 2005 5: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/