topic Convert String to Number in QlikView

Convert String to Number

hmjason7 — Wed, 11 Mar 2015 15:31:59 GMT

Hi All,

I need to convert a 16 character string into a number. The tricky thing is, the field is always a 16 character string in the form of:

"000000000001234" or "000000132454623" or "000000012300433".

As the last example suggests, I cannot simply trim all the 0's from the left hand side.

Any help would be much appreciated.

Cheers,

Jason

MK_QSL — Wed, 11 Mar 2015 15:35:54 GMT

Temp:

Load Num(Evaluate(Field),'#0') as Field Inline

[

Field

000000000001234

000000132454623

000000012300433

];

Anonymous — Wed, 11 Mar 2015 15:36:49 GMT

do you need the "0" also in form of number?

then use

num(stringnumber,'0000000000000000')

should work

or what do you want?

hmjason7 — Wed, 11 Mar 2015 15:41:07 GMT

Thanks, works like a charm.

hmjason7 — Wed, 11 Mar 2015 15:41:38 GMT

No I didn't need the 0. So if it was "000000000001234", I just wanted to return '1234.

awhitfield — Wed, 11 Mar 2015 15:41:54 GMT

You could also try this

LOAD
replace(ltrim(replace(number, '0', ' ')), ' ', 0) as number

Regards

Andy