iOS Question [Solved] Problems reading CSV files

[Deleted member 103]

Hi,

The CSV file (see attachment) can be imported in B4a, but not in B4i.
But if you convert the CSV file to UTF8, then it can be read in B4i.

Dim lstCSV As List = File.ReadList(File.DirDocuments, "test.csv")

Is it possible to automatically convert a CSV file to UTF8 format so that the user does not have to do anything when creating the file?

 

[Erel]

Use CSVParser + File.ReadString2 with the correct encoding.
[B4X] CSVParser - CSV parser and generator

 

[Deleted member 103]

Use CSVParser + File.ReadString2 with the correct encoding.
[B4X] CSVParser - CSV parser and generator

I have already tried this and it does not work either.

        Dim parser As CSVParser
        parser.Initialize
        Dim lstCSV As List = parser.Parse(File.ReadString2(File.DirDocuments, "test.csv", "UTF-8"), ";", False)
        Log("lstCSV.size= " & lstCSV.size)

lstCSV.size= 0

 

[Erel]

It is not utf8. Try windows-1252

 

[Deleted member 103]

It is not utf8. Try windows-1252

I know that it is not utf8.
I have already tried windows-1252 and all possible formats, unfortunately without success.

 

[Erel]

Dim s As String = File.ReadString2(File.DirAssets, "Test.csv", "iso-8859-1")

 

[Deleted member 103]

Dim s As String = File.ReadString2(File.DirAssets, "Test.csv", "iso-8859-1")

Hi Erel,

of course I have also tried with this format, unfortunately also without success.

Dim s As String = File.ReadString2(File.DirAssets, "Test.csv", "iso-8859-1")
log("s=" & s)

Log output:

s=

Meanwhile I think the error is in the routine "ReadString2", because I can't imagine that it doesn't give an error message if it can't read the file.
As already written, the file is read in Android without problems.

Question: did you try to read the file with B4i?

 

[Erel]

Question: did you try to read the file with B4i?

Of course. Works fine here.

 

[Deleted member 103]

Of course. Works fine here.

Hi Erel,
you are right as always. ?
I just noticed that the CSV file "Test_Timekeeper_komma.csv" was empty (see screenshot).
It can only happen when copying, because in Finder has a size of 191 bytes and in iPhone 0 bytes.

 

[emexes]

I just noticed that the CSV file "Test_Timekeeper_komma.csv" was empty (see screenshot).

This misnaming feels like a trap for future programmers.