How to remove alphabets and leading zerosin a column?

[#1]

load inline [

Department

emplyoye,

distribution,

G101010

GA201020

S081

G00089

GA00123

];

How to remove names,alphabets and leading zeros

Expected output:

Department:

101010

201020

81

89

123

Thank you

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD Num(KeepChar(Department, '0123456789'), '00') as Department;

load * inline [

Department

G101010

GA201020

S081

G00089

GA00123

];

[Kushal_Chawda]

try

Floor(KeepChar(Department,'0123456789'))  as Department

[#4]

Thanks for reply Sunny. It's working fine.