ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

How to remove comma between the numbers

EvansM
8 - Asteroid

Hello community,

 

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

 

Ex: 5,125 to 5125

 

Thanks

Emil_Kos
15 - Aurora

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
8 - Asteroid

Okay. Thanks lol

 

apathetichell
13 - Pulsar

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
8 - Asteroid

Thanks a lot

EvansM
8 - Asteroid

@apathetichell Thanks a lot

 

ArtiRajput
8 - Asteroid

 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
19 - Altair
19 - Altair

@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 reboot. Order shall return.
Please Subscribe to my youTube channel.
Emil_Kos
15 - Aurora

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.

ArtiRajput
8 - Asteroid

@MarqueeCrew Nice Video.

Labels