Try
lcStrNew = ;
STRTRAN( ;
STRTRAN( ;
STRTRAN( ;
STRTRAN( ;
STRTRAN(lcStr, [,"], CHR(01)), ;
[",], CHR(02)), ;
["], []), ;
CHR(01), [,"]), ;
CHR(02), [",])
>Hello,
>I've got a 30+mb text file that I need to put into a cursor. I've got the structure all figured out. The problem: The data is comma delimited, with double-quotes as the text delimiter. However, some of the fields contain the double quote character. My first thought was to just strtran() the whole thing and get rid of the quotes. This worked pretty good (took a little time), but then I discovered that some of the fields also contained a comma. I rolled my own parser and ran the file against it, but it took forever! ( well, actually I halted the process after about 15 min and it was something like 0.4% complete ). Anybody got any ideas. What I need to do is basically remove every double quote that is not immediately preceded, or followed, by a comma. Or am I just missing somehting simple somewhere ( I hope this is the case ). Thanks a lot,
>
>jfh
--sb--