New to VB.

Simply trying to parse the zip code out of a string and placing the zip code into a new string. Looking at the Split method, but unable to get code working w/o errors.

Sample string I am trying to parse is:

'Bakersfield,? CA? 93309

Any suggestions on the code snippet to remove the zip out of this string?

Thanks in advance. CT

well you could split it by the spaces but that would create 3 items and the last one would be the zip code:

Dim theItems() as String = theString.Split(new Char() {" "})

MessageBox.Show(theItems(theItems.Length - 1).ToString())

another way would be to get the lastindex of a space from that string: 

Dim theZipCode as String = theString.SubString(theString.LastIndexOf(" "))

One other way would be to use Regex - regular expressions but can be expensive. I'm not great at regex but some members here are and there is of course the resources from your fav search engine ;-)

Does this help?

Thank you for the quick response. I just figured out that I am actually inside the VBA 6.3 IDE launched from Excel. It seems the variable declaration is not as advanced in VBA as VB Express edition.

Would you know how to do this string extraction inside VBA 6.3 using a module? This way I am already 'inside' my Excel worksheet.

Thanks

CT

Ah!

Thread moved to the appropriate forum, they will help you more hopefully