Remove specific duplicate records

[jenner85]

Hi - I want to filter out the file where I have a "revised" file name. What is the best way to do this:

For example, I want to get rid of Feb 2013 and be left with Feb 2013-REVISED. thanks! 

[pedrodrfaria · Accepted solution]

Hi @jenner85 

See below for the workflow:

I'm using regex to clean up the fields to then flag the revised fields and using the sort and the unique to remove the unflagged duplicates.

This should do the trick.

Pedro.

[jenner85]

Hi @pedrodrfaria thanks for the workflow. Some of the file names don't have a space in them, can you help me with adjusting the regex to catch these as well? 

[pedrodrfaria]

@jenner85 

I tested with two rows without spaces and it worked. The regex is already considering the lack of spacing.

[jenner85]

@pedrodrfaria 

You're right. The issue seems to be here, where it's not removing it when revised is not spaced from the year: