Tab Delimited File

[Ot]

I have a Tab delimited file: Field1<tab>Fiel d2<tab>...<Fiel d20><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.inva lid (use net)> scripsit:

I have a Tab delimited file: Field1<tab>Fiel d2<tab>...<Fiel d20><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(v bTab)

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

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

I have a Tab delimited file: Field1<tab>Fiel d2<tab>...<Fiel d20><crlf>

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

Regards,
Ot