iOS Question [Solved] Problems reading CSV files

Deleted member 103 · Dec 27, 2021

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.

B4X:

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 · Dec 27, 2021

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

Deleted member 103 · Dec 27, 2021

Erel said:
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.

B4X:

        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 · Dec 27, 2021

It is not utf8. Try windows-1252

Deleted member 103 · Dec 27, 2021

Erel said:
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 · Dec 28, 2021

B4X:

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

Deleted member 103 · Dec 28, 2021

Erel said:

B4X:

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.

B4X:

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 · Dec 28, 2021

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

Of course. Works fine here.

Deleted member 103 · Dec 28, 2021

Erel said:
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 · Dec 28, 2021

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

This misnaming feels like a trap for future programmers.

iOS Question [Solved] Problems reading CSV files

Deleted member 103

Guest

Attachments

Erel

B4X founder

Deleted member 103

Guest

Erel

B4X founder

Deleted member 103

Guest

Erel

B4X founder

Deleted member 103

Guest

Erel

B4X founder

Attachments

Deleted member 103

Guest

Attachments

emexes

Expert

Similar Threads

iOS Question [Solved] Problems reading CSV files

Deleted member 103

Guest

Attachments

Erel

B4X founder

Deleted member 103

Guest

Erel

B4X founder

Deleted member 103

Guest

Erel

B4X founder

Deleted member 103

Guest

Erel

B4X founder

Attachments

Deleted member 103

Guest

Attachments

emexes

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency