Extraxct required data from string

[thumati.praveen]

Hi everybody,
my problem is extract requred data from string like

"12.32.345.23 datastage" this is my string,in this i want to extract some time numeric only(like 12.32.345.23) and some times i want to extract charecters only(like datastage).in server jobs code conversions is their,but in parlell jobs we can not use the ICONV,OCONV functions.

can you privide the solution for this problem.

Thanks,inAdvance.

[ray.wurlod]

Welcome aboard. :D

If it's always the case that the number will precede the remainder and a space will occur between them, you could use the Field() function.