Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Removing Comma from Concate

berty
8 - Asteroid

Hi all,

 

again a newbie here - only just learning this wonderful tool!

 

what is the simplest way to remove a comma from a concate formula field?

 

remove simgle ";" and replace with "-"

 

thanks

 

Bert

5 REPLIES 5
ArnavS
Alteryx
Alteryx

Hi berty,

 

You can create a formula using the Replace function, please see the example below:

Replace(Your_Variable, ",", "-")

 

Let me know if you have further questions. 

 

Thanks,

Arnav

Alteryx

JoshuaGostick
11 - Bolide

Hi @berty,

 

Maybe try using the Replace formula. It can look something like this:

 

Replace([Field1], ";", "-")

 

This will replace all instances of ; to a - in the column called Field1.

 

Let me know how this goes.

 

Thanks,

Josh

berty
8 - Asteroid

Both examples work, but I've noticed the that within the 2 concatenated fields the comma's have been replaced in there too!

 

how do i  keep any comma's in the original fields but only remove the concat separator?

 

kind regards

CharlieS
17 - Castor
17 - Castor

As a general note, when a concatanated string is created by the Summarize tool, the user can specify the separator character(s) as they desire. Also any prefix or suffix to the entire string. These settings are at the bottom of the Summarize tool when "Concat" is selected.

 

20191101-ConcatSettings.png

JoshuaGostick
11 - Bolide

Hi @berty,

 

Could you send an example or a sample just as a reference please?

 

Thanks,

Josh

Labels