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: [email protected]
To: <[email protected]>
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: [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/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
