Skip to content

Instantly share code, notes, and snippets.

@elpatron68
Created February 11, 2019 11:57
Show Gist options
  • Select an option

  • Save elpatron68/5362fe4ef2cd6cade4a71443a639f618 to your computer and use it in GitHub Desktop.

Select an option

Save elpatron68/5362fe4ef2cd6cade4a71443a639f618 to your computer and use it in GitHub Desktop.
Read csv file into 2-dim arry
Imports System.IO
Imports Microsoft.VisualBasic.FileIO
Module csv2array
Public Function _csv2array(ByVal sFilename As String) As Object
Dim dest As List(Of String) = New List(Of String)
Dim src As List(Of String) = New List(Of String)
Using csvParser As TextFieldParser = New TextFieldParser(sFilename)
csvParser.CommentTokens = New String() {"#"}
csvParser.SetDelimiters(New String() {","})
csvParser.HasFieldsEnclosedInQuotes = True
csvParser.ReadLine()
While Not csvParser.EndOfData
Dim fields As String() = csvParser.ReadFields()
dest.Add(fields(0))
src.Add(fields(1))
End While
End Using
Return {dest, src}
End Function
End Module
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment