>>Hi All
>>
>>I have a CSV file which uses comma as the primary delimiter between fields. However, some fields might contain a comma (e.g. a description field) and the supplier provides those fields enclosed in quotes. For example:
>>
>>AAA,BBB,"XXX YYY, ZZZ",CCC,"X1, Y1, Z1",DDD,
>>
>>I cannot do an import on this CSV file as it contains too many fields. I need to parse the file, line by line.
>>
>>How can I get each field so that the result would be:
>>
>>Field 1: AAA
>>Field 2: BBB
>>Field 3: XXX YYY, ZZZ
>>Field 4: CCC
>>Field 5: X1, Y1, Z1
>>Field 6: DDD
>>
>>GETWORDNUM() works for fields separated with a comma but then it picks up individual sections in the description fields which are enclosed in quotes. I can write a manual parsing routine but was wondering if there was a faster way.
>>
>>TIA
>
>Jos,
>
>You may want to have a look at the CSVProcessor class at
https://bitbucket.org/atlopes/csv.
>
>When you say your source file has "too many fields", does it mean "more than 254"?
Antonio, yes, over 650 columns ! Anyway will look at your class as it will surely be useful in other conversion projects, thanks!
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.