sdkn104 / vba-csv Goto Github PK

Currently, I am improving the CSVinterface class to make it RFC4180 standard fully compliant. As you know, your well developed project is used by me as a reference.

I test your code using the following CSV text and the returned value by your ParseCSVToArray function is null:

"Field with 
multiple lines" , "Another field 
with some 
line breaks inside" , "Include some  comma, for test" , Normal field here
1, 2, 3 ,4 
"Field 1", "Field 2" , Field 3 , "Field 4"

The above CSV complies the RFC4180 standard.

Would it be possible to implement a function that returns a Dictionary where either the first column is used for the key or you can provide a column number that would be used as the key. Most of the time the data I am working with needs to be obtained using a key in my code so I end up creating a Collection/Array and using that to create the Dictionary so it would be nice to just get a Dictionary.

I currently work on a CSV-VBA interface that I suposses'll to allow users exchange data between VBA arrays and CSV files, like your project do, but at really high speed. You claim your code is able to read CSV data at about 5.33 MB/sec., but in my test, on a fairly outdated laptop, the performance of it is frustrating. Some suggestion?