Names Repeat Fix

Question

Hi Guys,

I've come across an issue where I need to automate a report but problem is that Customer Names( first, middle and last) are being repeated, Below is a sample table, I've tried a few regexes but couldn't get anything.

First NameMiddle NameLast NameName I GetName  I WantRamKumar  Ram Kumar  Ram KumarRam Kumar  Ram Kumar  Ram KumarRam KumarRam Kumar Ram Kumar Ram Kumar Ram KumarRam KumarRam KumarRam KumarRam Kumar Ram Kumar Ram KumarRam KumarRamKumar KumarRam Kumar  KumarRam KumarRamRamKumarRam Ram KumarRam KumarSSubramaniyam S Subramaniyam S Subramaniyam S SubramaniyamS SubramaniyamS SubramaniyamS Subramaniyam S Subramaniyam S SubramaniyamS Subramaniyam

DataNath · Accepted Answer

How does this look @amit94? Perhaps not the most succinct but tried to approach this without RegEx. The workflow basically combines the names as they are before then splitting them into rows and eliminating duplicates for that record, therefore ignoring instances where the full name or parts of it have been repeated in multiple fields, before then combining back to the main data set. Let me know if you run into any issues when applying this to a larger set of records.

Edit: Added a Multi-Row to assign IDs to the words to get the right sort in the end.

Christina_H · Accepted Answer

I took a very similar approach, transposing the name columns and removing duplicates.

binu_acs · Accepted Answer

@amit94 One way of doing this