Tab Delimited File

[Ot]

I have a Tab delimited file: Field1<tab>Field2<tab>...<Field20><crlf>

There must be an easy way to break this apart, but I haven't found it yet.
Can anyone help?

Regards,
Ot

[Herfried K. Wagner [MVP]]

* "Ot" <ur***@tds.invalid (use net)> scripsit:

I have a Tab delimited file: Field1<tab>Field2<tab>...<Field20><crlf>

There must be an easy way to break this apart, but I haven't found it yet.

You can use 'Split' to split the lines.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Philip Rieck]

Sure. String.Split() is going to be your friend here. It will split the
string into an array of strings - for your example, splitting on <tab> would
give you an array of strings { "Field1", "Field2", "...","Field20"}

Here's an example that will read in each line, then print out each field on
it's own line:

------------------------------------
Imports System.IO

Module Module1
Sub Main()
Dim reader As New StreamReader("c:\filename.txt")

Dim oneLine As String = reader.ReadLine()
While Not oneLine Is Nothing
Dim vals() As String = oneLine.Split(vbTab)

'Do something interesting with the array of strings
Dim s As String
For Each s In vals
Console.WriteLine(s)
Next

oneLine = reader.ReadLine()
End While
End Sub
End Module
-------------------------------------------
"Ot" <ur***@tds.invalid (use net)> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...

I have a Tab delimited file: Field1<tab>Field2<tab>...<Field20><crlf>

There must be an easy way to break this apart, but I haven't found it yet.
Can anyone help?

Regards,
Ot