Alteryx Designer Desktop Discussions

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

Add thousand separator using regex

simon
11 - Bolide

How can I add a thousand separator (comma's) to a number that's in a string field using regex?

e.g. 112982 -> 112,982 

 

 

13 REPLIES 13
MarqueeCrew
20 - Arcturus
20 - Arcturus

I think that I was in the same Coma as you @GarthM

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
rs6833
6 - Meteoroid

Am I missing something?  The commas are not showing with the formal applied.  ToString([Sum_dr_total],0 ,1)

 

 

 

ivoller
12 - Quasar

@rs6833, I can't recreate that. Can you check that [Sum_dr_total] is numeric before entering the formula?

Bozhena
5 - Atom

Works perfect. Thanks for sharing the solution!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels