make split function ignore commers within quotes
I am looking for a way to effectively make the spilt function ignore commers that are within quotes. EG the csv file may look like:
10,some string value,"some, other, string, value",Yes,P99999
when I use the FSO to read the file I am using the split function to get this information into an array, do some things, then insert into DB. but of course "some, other, string, value" as seen above gets split into individual cells when the CSV is opened in Excel. I need this to appear in one cell.
Please note - passing the CSV file directly to the DB is not an option. I am being feed the CSV file so its a major hassle to ask for it to be re-formatted, probably no an option.
Wind is your friend