You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
Being in the excel thread I would definitely have listed the files in Excel (I have a macro which does this), transformed the file names using Excel text formulas and then used that to create a batch file which does the renaming (bonus points if you do all that by a macro).
When all you have is a hammer ...
aggi
Back again...
Bit pissed as I was led to believe that someone in our tech team had a script to do this, and would have otherwise done 20 a day for the last few weeks. But anyway thought I might try and crowdsource the issue. As I thought it may be possible to do part of it systematically in xls
Summary how do I bulk change word file names based on certain rules?
I have:
The current Naming convention is:
<(full location)> <[A]or[B]>.docx
ie crwd srcing lfgss (France) A.docx
The naming convention needs to be:
< ref code for the location >< location shortcode ><[A]or[B]>.docx
ie 1234_FR_A.docx
Does anyone know if there is a way to do this using Office tools, with out uploading any information online?
Cheers
Edit Some extra spaces added to the correct naming convention as otherwise it won't display