Well that'd be a good idea except (whispering) he said "data field" ;) doh...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dan Fitzgerald Sent: Wednesday, October 26, 2005 15:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] how to find records with a " in the data Why not just do a BASIC internal select & loop through the file, evaluating each id? open filename to fBad else whatevuh dblq='"' loop while readnext id do * note that you should test for null ids if you suspect that you have one if index(id,dblq) then * rebuild the id without the offending character. * loop through here if you have more than one in any given id * also maybe you want to capture which ones had the problem somehow * write the record back * delete the old record end repeat "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald >From: "George Gallen" <[EMAIL PROTECTED]> >Reply-To: u2-users@listserver.u2ug.org >To: <u2-users@listserver.u2ug.org> >Subject: RE: [U2] [UD] how to find records with a " in the data >Date: Wed, 26 Oct 2005 17:32:44 -0400 > >Try...just a guess. > >select filename with filename 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
