Parse delimited column

I have a column that holds delimited data

The delimiter is am exclamation point

How do I do a select and get back the results in a table?

Example data
lbrister!01/01/2011!0!25542!!
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
guveraCommented:
Dim str As String
        Dim strArr() As String
        Dim count As Integer
        str = "lbrister!01/01/2011!0!25542!! "
        strArr = str.Split("!")
        For count = 0 To strArr.Length - 1
            MsgBox(strArr(count))
        Next

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.