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.

Adding a comma between two words

JACKIEC1992
7 - Meteor

I am trying to add a comma between the state and the name. For example, currently, the top cell is NC South Park. I'd like it to be NC, South Park. 

2 REPLIES 2
cjaneczko
13 - Pulsar

Try this in a formula tool. Update "Studio" to whatever the fieldname is. The formula grabs the first 2 characters in the field, adds a comma and space, then trims the first three characters and adds the rest of the string to it. 

 

Left([Studio], 2) + ', ' + Substring([Studio],3)

 

KimLamNg
9 - Comet

@JACKIEC1992 One way to do this with RegEx tool

KimLamNg_1-1685536642641.png

 

Labels
Top Solution Authors