We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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!

Labels
Top Solution Authors