|I would be grateful for any help on a problem I have. This entails extracting data from files names and inserting it into an Excel file. Not wishing to reinvent the wheel I have searched, but without success, for how this could be achieved. |
Basically, I have a directory full of MP3 files. What I need is a script which will go through each of the files in the directory and extract the 3 parts of the file name together with the extension and save all these to a comma delimited csv file. The next bit I can do as it is straightforward as it involves just importing this csv file into Excel.
Each file name has the same format ie it has 3 sections separated by a hyphen and a tilde (alway in the same order) eg:
Blue Murder - The Screaming Habdabs ~ 1975 Lossiemouth Live In The Hanger.mp3
I need to save the data from each file in a csv file as:
Blue Murder,The Screaming Habdads,1975 Lossiemouth Live In The Hanger, MP3
I suspect that this will require Regex to achieve and that is probably beyond me!
Thank you for any help you can offer