You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
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
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)