Hello community,
I want to remove a comma between numbers on number data type column.
Ex: 5,125 to 5125
Thanks
Solved! Go to Solution.
Hi @EvansM,
A comma between numbers doesn't exist in reality. It is only showing to make it easier for you to read the numbers. 😀
Okay. Thanks lol
are they a real number type (ie a double). If not - it's a string.
If it a double - options
user settings
localization
see where it says thousand separator and you have comma - change that to none.
if it's a string replace([field],",","")
Thanks a lot
@apathetichell Thanks a lot
You can use Data cleansing tool to remove character like comma or any other punctuation.
Comma can also be removed using regex tool by creating regular expression.
Thanks
@EvansM ,
I added a response to demonstrate how to take the red pill ... @Emil_Kos .
As a "feature" of Alteryx, the results now display a thousands separator (and decimal) in the results. If you want to change or remove them, no problem.
I've attached the workflow used in the video.
Cheers,
Mark
Hi @MarqueeCrew,
I need to start recording videos as well as this is a really cool way to explain others how to solve their problem.
@MarqueeCrew Nice Video.