Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove alphabets and leading zerosin a column?

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Table:

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

load * inline [

Department

G101010

GA201020

S081

G00089

GA00123

];

View solution in original post

3 Replies
sunny_talwar

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

Not applicable
Author

Thanks for reply Sunny. It's working fine.