Convert String to Number

[hmjason7]

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 · Accepted solution]

Temp:

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

[

  Field

  000000000001234

  000000132454623

  000000012300433

];

[Anonymous]

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

then use

num(stringnumber,'0000000000000000')

should work

or what do you want?

[hmjason7]

Thanks, works like a charm.

[hmjason7]

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

[awhitfield]

You could also try this

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

Regards

Andy