MS Access 2003 Parsing Memo Field VBA
Posted on 2013-09-11
I need to parse a text (MS Access memo field) that is comma separated with double quotation marks as text delimiters AND commas as part of some text entries themselves. Overall data volume is about 300k records with 3800 chars in 500 columns. I need to extract about 50 columns from all records.
Looping through the records themselves and overall data handling is ok. I am now searching for the best performing way to parse through a single text record, figure out if I have the correct column, extract the data and then get the next column from the text. The index and order of the columns is known, of course.
1, "2", 3, "4," ,"5", ",6,a"
Commas after 4 and before and after 6 are NOT delimiters.
For example, I need to extract the second ("2") and sixth (",6,a") column.
Did somebody already solve this or something comparable in some smooth way?