'load csv
table1.loadCSV("filename.csv",",",true,true)
'read line by line
for i=0 to table1.count -1
'and add to arraylist, don't forget to fill in columnlist
al1.add(Table1.Cell(Columname,i))
Next
or the below, depending on the data
B4X:
please note this will not pick up the first item, but this usually has the column names
fileopen(c1,filename,cRead)
s = Fileread(c1)
Do Untill s = EOF
s = Fileread(c1)
'optional : If NOT(s = "@eof@") Then
al1.Add(s)
Loop
Fileclose(c1)
the straight answer is yes...
But it all deppends on how you are readding the csv..
are you using the table control to read/load the data to the table or using FileRead?
'load csv
table1.loadCSV("filename.csv",",",true,true)
'read line by line
for i=0 to table1.count -1
'and add to arraylist, don't forget to fill in columnlist
al1.add(Table1.Cell(Columname,i))
Next
or the below, depending on the data
B4X:
please note this will not pick up the first item, but this usually has the column names
fileopen(c1,filename,cRead)
s = Fileread(c1)
Do Untill s = EOF
'optional : If NOT(s = "@eof@") Then
al1.Add(s)
Loop
Fileclose(c1)