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!

Labels