View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RG III RG III is offline
external usenet poster
 
Posts: 65
Default Parse substrings

My input string is a set of numbers that represent prices.
Each price is separated by one or more spaces AND/OR tabs.
For example:

s = " 1200 300 25 2 4 10000 "

There might also be tabs separating numbers, such as:

s = " 1200[tab]300 25 2 4[tab][tab]1000 "

where [tab] is the location of an actual tab.

Assuming that my data will always have the following format,
what is a good way to extract each numerical value into
a variant or array?

I'm thinking the Split() function will help, but I'm kind of
thrown off because the separators could be spaces AND/OR tabs.

-Robert