I am having trouble with this formula. It seems to remove the commas (my delimiter) in all but the first set. I need to use the regex replace formula because I have multiple fields to edit and want to use the multi-field formula tool.
I changed it from "/w+" to ".+" since I have some non-alpha-numeric characters in my data. I don't care about the order of the output, just that they are unique. I can change the delimiter from comma to something else if that works better.
this is what I'm currently using: regex_replace([Regions Submitted],"\b(.+),(?=.*\b\1,?)",""). Sample data is attached.
Here is how I would like the formula to work:
output: CEN, NE, RM (order doesn't matter here, as long as the three unique values are present, separated by a comma or other delimiter)
input: ICE CREAM BLACK SESAME,ICE CREAM BLACK SESAME
output: ICE CREAM BLACK SESAME
input: BIOSIL® HAIR, SKIN, NAILS
output: BIOSIL® HAIR, SKIN, NAILS
input: HUMPHRY SLOCOMBE | HMSLCM | 129921,HUMPHRY SLOCOMBE | HMSLCM | 129921
output: HUMPHRY SLOCOMBE | HMSLCM | 129921