Num format from CSV

[dseelam]

  Hello All,

Once I export data from CSV item_number appears wrong as shown in attached QVW

eg:

Item Number format should be eg : 3305

But its appearing as 000000000000003305

How to convert back as 3305

It's not single item_number all item_numbers looks weird

Please check attached QVW

Thanks,

D

[tomasz_tru · Accepted solution]

When a string is too long it won't be converted to number. You can use evaluate function:

evaluate(ItemNumberField & '*1');

Tomasz

[antoniotiman]

Hi,

maybe

=Num(Right(ITEM_NUMBER,13))

Max nr QV digits is 14.

Regards,

Antonio

[qv_testing]

Try this,

Replace(LTRIM(REPLACE(ITEM_NUMBER, '0', ' ')), ' ', '0') as ITEM_NUMBER;