Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

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!!
0
lrbrister
Asked:
lrbrister
1 Solution
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now