Casting String to Number

[#1]

Hi,

I am having this issue, I am loading a column with 20 digits '60000000098634125780' and QV is getting it as a string but I need it to be recognized as a number.

I have tried num#(column) and it stills get it as a string and if I use the num() function it does not convert any value just drop them and leave them null.

What would you recommend to do?

Thank you for your time.

Ryu,

[Gysbert_Wassenaar]

That's too many digits to make a number from. QV supports 14 digits. Beyond that it will stay text.

[swuehl · Accepted solution]

Try evaluate() when reading in the field in your script:

LOAD

     evaluate(FIELD) as FIELD,

...

FROM ...;

[jagan]

HI,

Try this

=Num(60000000098634125780)

I am getting this as result 6.0000000098634e+019

Regards,

Jagan.

[#5]

Try num(num#(column) )..

[#6]

really thanks!

i don't know why but i couldn't suppress zeros (for example from '00000000232') with the num function, but using evaluating i could obtein it (for example 232)

[BhargaviPK]

that worked out for me! thanks!