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