Hi

i have input column data like this name and number
how to split name and number from input column

input_fld
abcd1.xyz(T1234)
abcd2.pqexyz(T4322)
abcd3.xyzeq(T4422)
abcd4.xyzds(T2321)

how to split string and number
output_fld1
abcd1 xyz
abcd2 pqexyz
abcd3 xyzeq
abcd4 xyzds

output_fld2
T1234
T4322
T4422
T2321
can any one help me plz

This message has been edited. Last edited by: Kerry,

Try GETTOK function

I think you need to check out the documentation, Functions Manual in particular, and apply some simple logic.

Try this:

 
-SET &INPUT = 'abcd2.pqexyz(T4322)';
-SET &LN = &INPUT.LENGTH;
-SET &VAL1 = GETTOK(&INPUT,&LN, 1, '(', 20, 'A20');
-SET &VAL1A = TRUNCATE(&VAL1.EVAL);
-SET &VAL2 = GETTOK(&INPUT,&LN, -1, '(', 20, 'A20');
-SET &VAL2LN = &VAL2.LENGTH;
-SET &VAL2A = STRREP(20, '&VAL2.EVAL', 1, ')', 1, '' , 20, 'A20');
-SET &VAL2B = TRUNCATE(&VAL2A.EVAL);
-SET &VAL2BLN = &VAL2B.LENGTH;

I would like to second Waz, Read The Focus Manual