Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Remove Successive Duplicate Words

j_mck
メテオロイド

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件の返信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
メテオロイド

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

ラベル