Names Repeat Fix

[amit94]

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 Name	Middle Name	Last Name	Name I Get	Name  I Want
Ram	Kumar		Ram Kumar	Ram Kumar
Ram Kumar			Ram Kumar	Ram Kumar
Ram Kumar	Ram Kumar		Ram Kumar Ram Kumar	Ram Kumar
Ram Kumar	Ram Kumar	Ram Kumar	Ram Kumar Ram Kumar Ram Kumar	Ram Kumar
Ram	Kumar	Kumar	Ram Kumar  Kumar	Ram Kumar
Ram	Ram	Kumar	Ram Ram Kumar	Ram Kumar
S	Subramaniyam		S Subramaniyam	S Subramaniyam
S Subramaniyam	S Subramaniyam	S Subramaniyam	S Subramaniyam S Subramaniyam S Subramaniyam	S Subramaniyam

[DataNath · Accepted solution]

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 solution]

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

[binuacs · Accepted solution]

@amit94 One way of doing this

[amit94]

Thanks a Lot, Guys!! It worked for me.👍