syntaxhelp.com Your online cheat sheet!

Read a Delimited Text File

'Namespace: Microsoft.VisualBasic.FileIO

Dim filename As String = "c:\syntaxhelp.txt"
Dim fields As String()
Dim delimiter As String = Delimiter

Using parser As New TextFieldParser(filename)
    parser.SetDelimiters(delimiter)
    While Not parser.EndOfData
        ' Read in the fields for the current line
        fields = parser.ReadFields()
        ' Add code here to use data in fields variable.

    End While
End Using