Parsing Data

Hi, I have a string that my program is receiving that is in the following format:

xxxxx;xxxxx;xxx;xxx;xxx;xxxx;0

There is 6 series of numbers (of varying lengths)...divided by a semicolon...and then ending with a ;0.

How can I parse out the last set of x's before the ;0?

Code:

---

Dim arrSeries() As String
Dim strSeries As String
strSeries = "xxxxx;xxxxx;xxx;xxx;xxx;xxxx;0"
arrSeries = Split(strSeries,";")

---

The last series of x's will be arrSeries(5)

Splitting on ";" will give you an array as posted by Hack. arSeries at Ubound(arrSeries) would be zero so your last batch of xxxx's would be at arrSeries(Ubound(arrSeries)-1)

Isn't that the same thing as arrSeries(5)?

Since you don't seem to be using the 0.. you can drop it off before the Split() function.

vb Code:

strSeries = Mid(strSeries, 1, Len(strSeries) - 2)

Works either way though. :)

Quote:

---

Originally Posted by SeanK

Isn't that the same thing as arrSeries(5)?

---

Didn't bother to count, my point of reference was the delimiter and zero, not the first character to the left. Parsing is mostly about repetitive patterns and selecting point of reference ...not just counting characters. what if there were hundreds of characters on either side?

As long as the delimiter is a semi-colon, it really wouldn't matter how many characters there were on either side.

But then he'd be counting semicolons to hardcode the index.

Valid point.