Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions

Re: How to remove alphabets and leading zerosin a column?

Try this:

Table:

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

load * inline [

Department

G101010

GA201020

S081

G00089

GA00123

];

3 Replies

Re: How to remove alphabets and leading zerosin a column?

Try this:

Table:

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

load * inline [

Department

G101010

GA201020

S081

G00089

GA00123

];

Re: How to remove alphabets and leading zerosin a column?

try

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

Not applicable

Re: How to remove alphabets and leading zerosin a column?

Thanks for reply Sunny. It's working fine.

Community Browser