Extract only "DIGITS" from a string?

[rockr]

Hi ,

Is there a function in parallel similar to DIGITS() in server. I have a string like

Ex: bnfcv56567uyuh

In a server job DIGITS(bnfcv56567uyuh) gives "56567" , I need the same functionality in a parallel job. How can I acheive it ?

The number in the string can be of any length, so I cannot extract the number by the position.

Please Help

[ArndW]

I'm not a place where I can check the functions, but I think this particular one and it's functionality is missing in PX. If you just have lowercase characters to worry about, you can use

Code: Select all

CONVERT('abcdefghijklmnopqrstuvwyz,'',In.Column)

Add uppercase and punctuation to that list if necessary. Basically the approach is to convert anything that is not a digit to empty in the string.

[divine]

http://dsxchange.com/viewtopic.php?p=26 ... 65a#269928

treat every character as special character except digits



or you can use CONVERT()

[rockr]

Thanks ArndW !

Works just great !