Removing Comma from Concate

[berty]

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

[ArnavS]

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]

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]

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 · Accepted solution]

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.

[JoshuaGostick]

Hi @berty,

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

Thanks,

Josh