Split member name from DataItem1 into DataItem2 and DataItem3

[Chamopak]

Hi,
I am trying to split the member name into 2 parts.
Is this possible, and if it is, please help me with these steps.


Data item 1                           Data Item 2   Data Item 3
1111000 - Text text text text   1111000           Text text text text

[adam_mc]

Use the position function to determine the position of the '-' assuming that is your delimiter between the the two fields.
Let's say this returns a value of X.
Then, for Data Item 2, substring out from position 1 thru (X-2) and for Data Item 3, substring out from position (X+2) thru the end.

Hope this helps.
Thanks,
Adam.

[Francis aka khayman]

adam's solution is good.

just for info purposes there is also a macro called split. i however have not tested it and am not sure if it will work for your particular example