Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

SOLVED

Converting text to number (from European to American decimal system)

Highlighted
8 - Asteroid

I have a data set with a character field which has basically numbers in European decimal convention (E.g. "2.567,834", "88.212,091"). I need to convert this field to numeric and also change the decimal convention to the American format (E.g. 2567.834, 88212.091). 

 

Is there a way to do it in Alteryx?

Highlighted
11 - Bolide

Hi @GaRaGe, you'll need to use the Replace function in the formula tool to replace '.' with nothing and then commas with a decimal point:

 

Replace(Replace([Field],".",""),",",".")

 

Then you can add a select after and change to a numerical datatype.

 

 

Highlighted
Alteryx Certified Partner

Hi GaRaGe,

 

A quick and dirty way of doing it would be in a Formula tool, just update the [Number] field as such: ReplaceChar(ReplaceChar([Number],".",""),",",".")

This will result in a string, if you need it to be a number in your local settings just add ToNumber() to the whole string. (mine is European so that would just revert back to original string)

 

Hope this helps

 

//Anders

Labels