Android Question CSV Breakline or CRLF

[metzeller_2013]

Good Day to all,
I'm currently using sqlite and exporting my data to CSV format as my data output.... Everything goes well, but i noticed the output csv using string utility (su.savetoCSV) does not have a breakline to separate each row.
Is there a way to put a breakline to separate each row in the CSV?
TIA....

 

[LucaMs]

SaveCSV adds a "breakline".

The List to save must contain arrays of strings.

For example:

Private Arr1(2) as String
Arr1(0) = "One"
Arr1(1) = "Two"
MyList.Add(Arr1)

Private Arr2(2) as String
Arr2(0) = "Three"
Arr2(1) = "Four"
MyList.Add(arr2)

su.SaveCSV(Dir, FileName, ",", MyList)

 

[Erel]

I'm currently using sqlite and exporting my data to CSV format as my data output.... Everything goes well, but i noticed the output csv using string utility (su.savetoCSV) does not have a breakline to separate each row.

The end of line character in Android is Chr(10). If you are using Notepad then you will not see it.

The solution is to use a better text editor such as Notepad++.

 

[metzeller_2013]

thanks for the reply sir erel and sir lucaMS,
That's the reason why i can't see it..... What i see is a small square ascii character.... is there a way to replace it with the regular CRLF?

 

[Erel]

You can read the saved text with File.ReadString and then convert the end of line characters:

Dim t As String = File.ReadString(...)
t = t.Replace(Chr(10), Chr(13) & Chr(10))
File.WriteString(..., t)

 

[metzeller_2013]

Thank you very much for the reply sir Erel, I'll try this one.....