Sorry if the subject is confusing. I currently have a field that looks like this. "SHV-IAH-IAH-CUN-CUN-IAH-IAH-SHV" I need to be able to delete only the consecutive duplicates so it would look like this. "SHV-IAH-CUN-IAH-SHV". Thank you.
Hi, @jsatt @chandler-gjino
If you can use regex to formula , the case will be so easy.
[ Perhaps you need show more form cases for compatibility .]
REGEX_Replace([Txt], '([[:alpha:]]+)-\1', '$1')
******
If can help you get your want, please mark it as a solution and give a like for more share.
attaching a solution.I parsed the string using text to columns and "-" as the delimiterafterwards, I used the multi-row formula tool to null any duplicatesI filtered out the now null duplicates, then resorted just in case, to ensure the same orderthen used the summarize tool to concatenate back togetherhopefully this helps!
Chandler, thank you for this. This works for my example. Unfortunately I need to run this on a large dataset so this exact workflow may not work. However, I think your Multirow formula tool will send me down the right path. I really appreciate the quick help!
