General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cleaning data before append
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only