How can i extract a certain field from a TAb delimited String

I am trying to extract the 10 field from a tab delimited text field..
i think the split function should do the trick but i am not sure how do i specify the delimiter as a tab

AlexPonnathAsked:
Who is Participating?
 
bman9111Commented:
little example of how to split a file:

   Dim test As String
        Dim break() As String
        test = "this jj jj kk"
        break = test.Split(" ")
        MsgBox(break.Length)

        Dim i As Integer
        For i = 0 To break.Length - 1
            MsgBox(break(i))
        Next

can u give me one of ur line example???
0
 
AlexPonnathAuthor Commented:
i figured out my problem...

i need to use a chr(9) as the delimiter...

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.