Nesting Function Help!!!

[mrowe]

Hi,

I have a field in a report that has 3 strings of text separated by a space, but not fixed length.

i.e CTAX100 CEDRT00001 CRT948
CTX093 CTEX30344 CWERT4DD

My mission is to split theses into 3 collums.

I've tried using SubString and Pos to pull apart but with no luck.

I could do with some help on nesting or another solution if possible.

Thanks in advance
Matt

 

[promero]

If I have not missed something, it would be like this:

<COL1> = Left(<COL>, Pos(<COL>, &quot; &quot - 1)

<COL2> = Left(SubStr(<COL>, Length(<COL1>&&quot; &quot+1, 1000), Pos(SubStr(<COL>, Length(<COL1>&&quot; &quot+1, 1000), &quot; &quot - 1)

<COL3> = Left(SubStr(<COL>, Length(<COL1>&&quot; &quot;&<COL2>&&quot; &quot+1, 1000), Pos(SubStr(<COL>, Length(<COL1>&&quot; &quot;&<COL2>&&quot; &quot+1, 1000), &quot; &quot - 1)