homesick1337
Computer Lover
- Joined
- 20 Jan 2004
- Messages
- 129
Here’s my problem: I have lots of CD-Rs full of mp3s and other files. I want to put the CD in the CD drive, run the program, the have an excel file with a list of the files on the cd.
For example, my CD-R has:
Artist - Song Title.mp3
Artist 2 - Song Title.mp3
Artist 3 - Song Title.mp3
I want to have an excel (or text file) with:
Artist - Song Title
Artist 2 - Song Title
Artist 3 - Song Title
For obvious reasons, I do not want to type out every name.
So far, the best thing I have is a .bat file with this code: “dir d:\*.* /a/o/s > list.txt” which creates a text file with the date time, and a whole bunch of other crap. This is usable with the assistance of Excell’s text to columns feature, but I want something better.
Does anyone know of a better program?
For example, my CD-R has:
Artist - Song Title.mp3
Artist 2 - Song Title.mp3
Artist 3 - Song Title.mp3
I want to have an excel (or text file) with:
Artist - Song Title
Artist 2 - Song Title
Artist 3 - Song Title
For obvious reasons, I do not want to type out every name.
So far, the best thing I have is a .bat file with this code: “dir d:\*.* /a/o/s > list.txt” which creates a text file with the date time, and a whole bunch of other crap. This is usable with the assistance of Excell’s text to columns feature, but I want something better.
Does anyone know of a better program?