Search tool to sort files by index
I’m searching the internet like crazy.
I am trying to find a tool to sort my drawing data. They always come in pairs as pdf and dwg.
Whenever a drawing is updated, it gets a higher index in the file name,
Index 0: “[Project]_[Type]_[Drawing]_—_[Status]”.
Index 1: “[Project]_[Type]_[Drawing]_aa0_[Status]”
Index 2: “[Project]_[Type]_[Drawing]_ab0_[Status]”.
Many different drawings are now stored in one folder, sometimes with subfolders.
Of course with different old indexes that are no longer up to date.
I would now like to have only the latest version of all drawings.
Those with old indexes should be moved to an archive folder.
Problem number 2 is that the [status] (f/g/p) in the file name is irrelevant.
Ergo, the last 2 letters in the file name should be ignored when sorting.
Does anyone know a tool for this? Or one where you can set the rules like this?
That would be a great help!