Skip to Content
0
Former Member
Apr 15, 2014 at 03:59 PM

HOW TO EXTRACT NUMBER FROM ALPHANUMERIC?

1815 Views

Hi

I am using BODS 14.1.1.210

I would want to extract just numbers from the alphanumeric column as shown below. How can I achieve this?

INPUT OUTPUT

ABC_12 12

A@20MN 20

BMX>56 56

34MNB 34

Cheers!