-
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)
chez_jay-
Lol yes.
Annoyingly someone with python skills from our consulting team said they could help me with it, but I didn't have the time to write a proper story and work out the logic.
I think I'll see if I can do a semi automated version to work out the file names. Then try and do it while watching TV tonight or something.
However, because of the free text of the OG file name, there isn't a strict 1 to 1 mapping being the fields.
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