Cleaning a column in alteryx

[NadaH]

Hello everyone,

I have an issue trying to clean the a column on my workflow.

I got this table and would like to clean column A by removing the occurrences

A	B	C
hi,hi,hi,hi,hello	1	45
ab,ab,an,an	2	54
de,bon,bon	3	32

I should have this result:

A	B	C
hi,hello	1	45
ab,an	2	54
de,bon	3	32

Thank you in advance for your help

[atcodedog05]

Hi @NadaH 

In the below formula

REGEX_Replace([A]+",", "([^,]+,)\1+", "$1")

([^,+]) - represents series of character with no commas in between. Which constitutes a value like supply - sav

\1+ - represents same above word repeated more than once

If value is repeated replace it only with single occurence.

Regex is something takes practice to get good at 😅

Here is a resource which might help https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

Hope this helps : )