Hello all - i apologize if this has already been asked in another form but I tried searching a few different ways and couldn't come up with any results specifically to what I'm looking for.
My request is pretty simple but i'm not familiar at all with RegEx and I'm hoping this isn't too complex.
I have a few hundred files that all start with a person's name, an entry number and a following A, B (sometimes C or D) and they were labeled pretty inconsistently to begin with. That being said, all I want to do is target that last A, B, or C after a string of numbers (3 digits) and change the character (if it exists) to -Section1, -Section2 etc... but some of them don't have a letter at the end and I only want to change that last letter (if it exists) to a "Section1" or "Section2" respective to the A, B, C ... )
An example of a few different file names:
JohnP-001.doc
JohnP-002A.doc
JohnP-002B.doc
Sara-C-Paper010.doc
Sara-C-Paper011A.doc
Sara-C-Paper011B.doc
And I want to rename them as follows:
JohnP-001.doc
JohnP-002-Section1.doc
JohnP-002-Section2.doc
Sara-C-Paper010.doc
Sara-C-Paper011-Section1.doc
Sara-C-Paper011-Section2.doc
Thank you in advance for your help!