hi there, i've been importing xls files and changing the fields from V_string to double and realized the numbers get truncated specifically at the "," and loses decimal places.
eg 20,888.90 becomes 20 and 1000.4032 becomes 1000.40
I repeated the same with xlsx folders and it works fine -20888.9 and 1000.4032 shows.
Is this a limitation working in xls?
Appreciate any workarounds.
I've attached screenshots and the working files.
Hi @domlow,
You'll want to remove the commas before converting to numeric data types when using xls files. If you've got multiple fields to replace the commas from you could use a multi-field tool! 🙂
Once you've removed the commas we can then change the data type as normal.
I've attached my workflow for you to download if needed.
Kind regards,
Jonathan
Thanks @Jonathan-Sherman
I tried that, but the data is still not showing in full, ie 1000.4032 is only showing as 1000.4 from the xls file
Any way to show the full values?