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