I find it strange that you have the separation character the same as the decimal character.
How is this csv file build?
Couldn't you use ";" as the separation character, like Excel does.
The CSV file is build by Paypal (activity history) I can also make a tab separated file, but I don't know how to split a tab separated line.
If you know how, the help will be welcome
For keirS:
The stringutils could work but the character set of the file is encoded in WINDOWS-1252 and I get accentued french character that the stringutils import don't have.
When it doesn't want to work it don't work
Dim Spllited() As String
Spllited = Regex.Split($",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)"$,$""dd/MM/yyyy","08:27:36","CEST","xxxx ","xxxxx","Terminé","EUR","40,10","","40,10""$)
For i = 0 To Spllited.Length - 1
Log(Spllited(i))
Next
You don't want to do that in the Split as you would get different lengths of array due to empty values.
B4X:
Spllited = Regex.Split($",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)"$,$""dd/MM/yyyy","08:27:36","CEST","xxxx ","xxxxx","Terminé","EUR","40,10","","40,10""$)
For i = 0 To Spllited.Length - 1
Log(Spllited(i))
If Spllited(i).IndexOf($"""$) > -1 And Spllited(i).Length > 2 Then
Log(Spllited(i).SubString2( Spllited(i).IndexOf($"""$)+1,Spllited(i).LastIndexOf($"""$)-1))
Else
Log("Empty")
End If
Next