Solved Split text based on a common value

rpaccount

Member
Hi all,

Need help to split text

XXX > XXX > XX
XX > CC > AAAAAA

Characters can vary in length but the common thing is that all have >
Need to split it accordingly.
E.g.
XX goes to Column 1
CC goes to Column 2
AAAAAA goes to Column 3

Thanks!
 

VJR

Well-Known Member
Hi rpaccount,

You can refer Post #2 here.
The only difference is in the above link the position of the space is found. In your case you need to find the position of >.

Taken from the above link, without testing I am guessing that the below would be the Multi Calc stages for you. But you need to run and check that out.

Trim(Mid([Input], 1, InStr([Input], ">")-1))
Trim(Mid([Input], InStr([Input], ">")+1, [LastPosition]-InStr([Input],">")))
Trim(Right([Input], Len([Input]) - [LastPosition]))
where LastPosition is the position of the last > returned by the InstrRev function.
 
Top