This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have one column that has currency in output getting below warning. Could you please help me out .
"USD Amount: 17,576.65 Stopped converting at a comma. It might be invalid"
Go to Solution.
Go to Solution.
before the select tool try using a formula tool that says
Replace([USD Amount], ",", "")
That will remove the comma and allow for you to change the data type to a number.
Exactly what @BrandonB said but you will need to use a Multi-Field Formula tool instead of a regular Formula tool to change the field type without changing the field name.
Thank you for your quick response
. It's working fine but again getting a new warning as 'ConvError: Select (27): USD Amount: "532.38" has too many digits after the decimal and was truncated.'
are you trying to convert to integer? try converting to double.
Integers are whole numbers only.
@Lalaiah To increase the length, maybe use a Fixed Decimal type?
I tried both
For Double: " ConvError: Select (27): USD Amount: ########### is not a valid number."
For Intgr : "ConvError: Select (27): USD Amount: 532.38 lost information in translation"
For Fixed Decimal: "ConvError: Select (27): USD Amount: "2513.10" has too many digits after the decimal and was truncated."
What are your options/user settings/localization set up for?
and you can confirm you are selecting the fields in a multi-field tool, using tonumber([_currentfield_]) in the formula and clicking on change type to double?
Same warning I am receiving.
Even i tried for sie 255.0
use the multi-field tool with the options I discussed above. If that doesn't work can you post more numbers? and it may be time for THE REGEX SOLUTION.