Hi everyone,

Driving me crazy! I had done it for some one long time ago now I can't remember how and I don't have the code!

I have a text like this in a single text variable:

"1. Bc4 Na2 2. Ka8 Bc3 3. Bxe4 f2 4. Kc2 Qa4"
and so on, goes up to probably 60 numbers. (e.g. 60. Ba4 Kc2).

What I want to do is to get them separated in array, I know the syntax of Split function in vb6, but I don't know what condition to use as I couldn't find a chance with wild cards in vb6.

I eventually want to get it as:
1. Bc4 Na2
2. Ka8 Bc3
3. Bxe4 f2
4. Kc2 Qa4
....

It means using wild cards it would be like split(variable, "?.") as the question marks represents one single character (numeric value would be more precise!).

But there are apparently not actual wild cards in vb6.


I can not use the space condition because there are some more spaces that I dont want them to be breakpoints.

I can't use dots because it would become like this:
1
Bc4 Na2 2
Ka8 Bc3 3
...

(I know with a little manipulation one would correct the above one, but its a software that needs reliable coding not to get the string apart like this then stick it together again... doesn't feel correct).



In advance, thanks for ideas.