11-21-2008 02:25 PM
11-21-2008 02:46 PM
Use the String matching functions in a while loop with a shift register to parse the string. Then convert the numeric string parts to numbers and put them in the arrays. There are several string functions. Look at them to see which will work best for your case.
Lynn
11-21-2008 03:13 PM - edited 11-21-2008 03:13 PM
You actually do have a convenient delimiter: "time". Thus, you can make an array using that as the delimiter. Only caveat is that the first array element will be empty. Then you can conveniently use the Scan From String function in a for-loop. Something like this: