Solved! Go to Solution.
Hi @kamel1002
I would look at dealing with this more dynamically as your Replace() function may be missing some of your text values.
Are the values all in the format number-space-currency? If so, you could use a text to columns to split the numeric and the currency into different fields.
Alternatively, you could leverage the RegEx parse tool or RegEx functions in the Formula tool to remove any text characters:
Hope this helps. Let me know if you have any more questions.
Luke
Hi @kamel1002
What about taking a Multi-Field tool approach, to strip everything that is not a number from your field.
Here, I'm using Regex_Replace to look at both columns, and replace any non-number value with nothing. I've created 2 new fields to store the numbers, and there were no conversion errors. I love this approach because you can assign a data type to the new fields (and even change data type of an existing field!), and apply the same formula to both columns.
Let me know if that helps.
Cheers!
Esther