I need to remove all the chars from an alpha numeric string ('AL234ps12;') to get 2342 as the result or
fetch 2342 from the an alpha numeric string ('AL234ps12;').
could anyone give me some idea plz.
Thanks & Regards,
string ('AL234ps12;') looks like it contains 1 and 1 is numeric. Do you want 1 also like 1234 from the string?
You can use
Source column is having a string value like 'AL234ps12w' and i need the output without characters, that is only numeric values 23412 as the output value to be stored in target column.
There's an old trick utilizing nested oTranslate: remove all characters you want to keep and then use this as characters to be removed:
oTranslate(x, oTranslate(x, '0123456789',''), '')