B4A Library [B4X] CSVParser - CSV parser and generator

CSV - comma separated values format.

The various StringUtils libraries include methods for loading and saving CSV files.

However these methods have a few drawbacks:

- They work with files instead of strings. This is especially problematic if the input is not UTF8 encoded.
- As they are implemented inside a native library it is not possible to modify their behavior. Some CSV files are not 100% valid and will not work with these methods.

CSVParser is a class that allows parsing and generating CSV strings:

Dim parser As CSVParser
parser.Initialize
Dim table As List = parser.Parse(File.ReadString(File.DirAssets, "1.csv"), ",", False)
For Each row() As String In table
   'work with row
Next
Dim s As String = parser.GenerateString(table, ",")
File.WriteString(File.DirApp, "1.csv", s)

 

[alwaysbusy]

Any reason it is called CLVParser instead of CSVParser (title)?

 

[vecino]

Any reason it is called CLVParser instead of CSVParser (title)?

I have thought the same.

 

[Erel]

Any reason it is called CLVParser instead of CSVParser (title)?

Too many days of vacation.

The name is of course CSVParser (although it is also a generator...).

 

[alwaysbusy]

I wrote, some time ago, a CSV parser too and I can't recall the times I miswrote those simple three letters (CVS was my 'favourite') #ItIsACurse

 

[LucaMs]

The real reason is that Erel (and all of us, I think) loves CLV (xCLV)