Regex Issues

krishnagandhi

So i have a regex formula to help me clean duplicate job titles in my job title field... i thought it was working group but if you look at my workflow row 21 there should be a comma between the first and second job title and instead it just joined both titles in one long word. Can anyone look at my regex formula and tell me what i'm doing wrong... been driving myself crazy trying to figure it out.

TRIM(REGEX_Replace([Concat_Job Title], '\b(.+),(?=.*\b\1,?)', ''))

Thanks!

Regex.yxmd

krishnagandhi

Thanks for all the help guys. What i ended up doing is the step where i concatenate the job title data (Summarize Tool) i did a group by job title and then used a second summarize tool and i concatenate the job title since now i only had unique job titles. This was the easiest way to get the job done!