Regex Formula Help

[blwhitehorne]

Hello,

In the attached workflow I am using a regex formula to remove duplicate values after concatenating them using a summarize tool. The second formula just adds a space to make it more pleasing to the eye. I use this formula in several workflows and typically have great results. Recently I have found that this formula only works when concatenating single values that do not contain spaces or special characters. I have examples of each scenario in the attached workflow. Is there a different expression I can use for the values with spaces or special characters? Thanks in advance for any help!

[johnyli168 · Accepted solution]

Hey there,

See my response below without using any regex. 

I've also attached the workflow so you can have a look at it.

[blwhitehorne]

Ahh, makes perfect sense. Thanks!