Readinfileg from a .CSV

[bishmedia]

Cant find much tutorial on here for reading from a .csv file, i found some code using StringUtils but its not reading the pc.csv file i have placed in the 'Files' folder. I get...

java.io.FileNotFoundException: /mnt/sdcard/pc.csv: open failed: EACCES (Permission denied)

Here's what i borrowed in the hope of logging the results....
Which line is wrong??

Sub Globals
   Dim List1 As List
End Sub

Sub Activity_Create(FirstTime As Boolean)

    Dim Reader As TextReader
       Reader.Initialize(File.OpenInput(File.DirRootExternal, "pc.csv"))
       Dim line As String
       line = Reader.ReadLine
       List1.Initialize
      
      Do While line <> Null
          Dim LineArray() As String
          LineArray = Regex.Split(";", line)
          Log(LineArray)
          'List1.Add(LineArray)
           line = Reader.ReadLine
      Loop
      
End Sub

 

[margret]

If you put the file in the files folder, it will be at: File.DirAssets and not File.DirRootExternal.

 

[bishmedia]

Ok its scrolling through the data but im getting some weird results through the listview...

[Ljava.lang.String;@40d0fbf0

Sub Activity_Create(FirstTime As Boolean)
How would i say populate the listview with the first line?? 
AB11, AB12 etc

    Activity.LoadLayout("csv_listview")
    Dim Reader As TextReader
       Reader.Initialize(File.OpenInput(File.DirAssets, "pc.csv"))
       Dim line As String
       line = Reader.ReadLine
      
      Do While line <> Null
          Dim LineArray() As String
          LineArray = Regex.Split(";", line)
          ListView1.AddSingleLine(LineArray)
          line = Reader.ReadLine
      Loop
      
End Sub

my csv has tables like.......

AB10   392900   804900   57.13   -2.11   Aberdeen    Aberdeen 
AB11   394500   805300   57.13   -2.09   Aberdeen    Aberdeen 
AB12   393300   801100   57.1   -2.11   Aberdeen    Aberdeen 
AB13   385600   801900   57.1   -2.23   Milltimber   Aberdeenshire 
AB14   383600   801100   57.1   -2.27   Peterculter   Aberdeenshire 
AB15   390000   805300   57.13   -2.16   Aberdeen    Aberdeen 
AB16   390600   807800   57.16   -2.15   Aberdeen    Aberdeen 
AB21   387900   813200   57.21   -2.2   Aberdeen    Aberdeen

 

[margret]

The CSV file reads into the ListView a list of arrays. This is why you don't see your data yet. You will have to pull the data out of the array element before you add it to the listview.