Android Question Question Stringutils loadcsv

F

fatman

Active Member
Licensed User
Longtime User
Hi to all,

i´m trying to import a csv-file like that: mylist = su.loadcsv(file.dirrootexternal...
which is no problem.
The csv-file contains several colums like: "column1","column2","column3", etc
Every line in mylist contains an array.
Stupid question: how to get access to each element in every array?

Every hint is welcome.

Fatman
 
Sort by date Sort by votes
DonManfred

DonManfred

Expert
Licensed User
Longtime User
show us your code to load the csv.
It will be easier to answer your question.

B4X: 
For Each Row() As String In su.LoadCSV (File.dirrootexternal,"my.CSV",",")
' You can access the LINE with
' dim s as string = Row(0) ' 1. line
'dim values() as string = Row(0) ' get the columns from one line...
' use values to the access the columns... 0 to x (values(0) 1st column, value(1) the second....)
For Each n As String in Row
   Log(n)
Next
Next
 
Upvote 0
Gary Miyakawa

Gary Miyakawa

Active Member
Licensed User
Longtime User

Don,

Thank you for this but for the life of me, I can't get the column information without using regex.split. I KNOW I'm doing something wrong... Your example code got me close but still struggling with the columns. Could you complete the example in working code ?

Sorry for my stupidity today...

Gary Miyakawa
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4A Class TD_Toast
Replies
0
Views
457
Guenter Becker
M
  • Article
Android Example Import a CSV Text File Into a Newly Created SQLite Table
Replies
2
Views
2K
Mariano Ismael Castro
  • Question
Android Question Reading list entries into an array
Replies
3
Views
1K
eurojam
E
  • Question
String to Byte from CSV
Replies
2
Views
2K
enonod
E
S
  • Question
Can you add a column to a csv file?
Replies
3
Views
2K
sonistp
S