Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
When a string is too long it won't be converted to number. You can use evaluate function:
evaluate(ItemNumberField & '*1');
Tomasz
When a string is too long it won't be converted to number. You can use evaluate function:
evaluate(ItemNumberField & '*1');
Tomasz
Hi,
maybe
=Num(Right(ITEM_NUMBER,13))
Max nr QV digits is 14.
Regards,
Antonio
Try this,
Replace(LTRIM(REPLACE(ITEM_NUMBER, '0', ' ')), ' ', '0') as ITEM_NUMBER;