How to remove comma between the numbers

[EvansM]

Hello community,

I want to remove a comma between numbers on number data type column.

Ex: 5,125 to 5125

Thanks

[Emil_Kos · Accepted 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. 😀

[EvansM]

Okay. Thanks lol

[apathetichell · Accepted solution]

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],",","")

[EvansM]

Thanks a lot

[EvansM]

@apathetichell Thanks a lot

[Alteryx_AR]

 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

[MarqueeCrew]

@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

@NeilR 

[Emil_Kos]

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.

[Alteryx_AR]

@MarqueeCrew Nice Video.