Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to remove comma between the numbers

EvansM
9 - Comet

Hello community,

 

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

 

Ex: 5,125 to 5125

 

Thanks

12 REPLIES 12
Emil_Kos
17 - Castor
17 - Castor

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. 😀

 

 

Emil_Kos_1-1619636131633.png

 

EvansM
9 - Comet

Okay. Thanks lol

 

apathetichell
18 - Pollux

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
9 - Comet

Thanks a lot

EvansM
9 - Comet

@apathetichell Thanks a lot

 

Alteryx_AR
12 - Quasar

 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
20 - Arcturus
20 - Arcturus

@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 

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Emil_Kos
17 - Castor
17 - Castor

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
12 - Quasar

@MarqueeCrew Nice Video.

Labels