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!
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.
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?
