We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Remove Successive Duplicate Words

j_mck
6 - Meteoroid

Hello, I am trying to figure out Regex (or another way) to get rid of successive duplicate words in a very long text string. For example, my text starts with: "Office Office Serial Serial number number" and I would like it to read "Office Serial number"

 

The text fields are large and it is throughout the string.

 

Thanks!

2 REPLIES 2
RogerS
Alteryx
Alteryx

Hi Julie,

 

Attached workflow removes duplicates in two different ways.  One removes all duplicates and the other only removes sequential duplicates.  Hope this helps.

j_mck
6 - Meteoroid

Thanks so much!!! This is exactly what I was looking for :-)

Labels
Top Solution Authors