You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
You could have done about a third of the job manually in the time you took to analyse, find out there is no script and then write this post.
I would have done exactly the same 👍
(I'd probably do it in Python these days and make it platform independent, write a test suite, handle Unicode, command line options, and it'd be ready in 6-8 weeks)
-
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 ...
chez_jay
aggi
@hugo7
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