splitting arrays

[Mike D]

I have a string that looks like this: a|b|c|d%e|f| ...

I split once on "%"

ar1 = Split(Mystring, "%")

then when I try and split the ar1 by

ar2 = Split(ar1, "|")

I get error '800a000d' Type mismatch

I have tried
ar2 = Split(Cstr(ar1), "|")

How can I split this string?

Thanks
Mike

 

[Bob Lehmann]

ar2 = split(ar1(0), "|")

You will probably want to loop through ar1 instead of writing each one out
though.

Bob Lehmann

 

[Mike D]

Thanks. It's been a hard Monday.

Mike

ar2 = split(ar1(0), "|")

You will probably want to loop through ar1 instead of writing each one out
though.

Bob Lehmann