Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cleaning data before append
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cleaning data before append
Miscellaneous
Thread ID:
00754250
Message ID:
00754250
Views:
36
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
Next
Reply
Map
View

Click here to load this message in the networking platform