[RESOLVED] Forgotten String Parser

Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.

Example:
TS = "123|456789|A|BCDEF|GHI|JK"
-or possibly-
TS = "123&456789&A&BCDEF&GHI&JK"

Results:
A(0) = "123"
A(1) = "456789"
A(2) = "A"
A(3) = "BCDEF"
A(4) = "GHI"
A(5) = "JK"

As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements.

Please, PLEASE somebody jog my memory and point me in the right direction. :wave:

Thanks in advance :blush:

Geoffrey

TS = "123&456789&A&BCDEF&GHI&JK"
Ts.Split("&"c)

Yes!!! Thank you! I spent two days looking and you solved in 10 minutes. \

Very much appreciated!