DSXchange

Hi,

Is there a function in DataStage which will return only numbers when an alpha-numeric string is passed as input to the function?
If not is there any other way to achieve this without using a routine.

Ex:
If input (919)-9727, the output should to be 9199727

Thanks,
Abhinav

There is the DIGITS transform that will do that for you.

Thanks Craig.