How to read a CSV with selective text qualifiers into a database using ASP Classic
Posted on 2010-09-08
I am using ASP Classic to read a CSV and import it into a database. The data file I am given only has selective text qualifiers; i.e. if a field has a comma, the field is surrounded by a double quote. Therefore, the file has both fields surrounded by double quotes and fields surrounded by nothing.
In other words, the file looks as follows:
John Doe,"123 Main St., Apt. 4",Athens,GA
How do I read this file properly into a DB when there are comma delimiters within the field?
For background, I am currently using a Excel macro called "Text Write Program" to convert the CSV into a pipe-delimited TXT, which my ASP script can read properly. But I am looking to cut out this manual workaround.