i want to index the contents of 60 or so MP3 cd's, in MS Excel.
does anyone know a quick way of doing this?
at the moment my method is based around using a cmd prompt "dir >filelist.txt", then opening/importing the txt file in excel.
the problem with that is i need a way to customize the output of dir, to show preferably only the filename (and not time/date/size etc). because excel needs to be given 'tokens' to recognise the data in each line of the dir listing. if only the filename is listed i can use "-" as the token:
EG
artist1 - title1.mp3
artist2 - title2.mp3
rather than
time date size,000,000 artist1 - title1.mp3
and so on
thx!
edit: i dew apologize, i've just discovered the /b switch
does anyone know a quick way of doing this?
at the moment my method is based around using a cmd prompt "dir >filelist.txt", then opening/importing the txt file in excel.
the problem with that is i need a way to customize the output of dir, to show preferably only the filename (and not time/date/size etc). because excel needs to be given 'tokens' to recognise the data in each line of the dir listing. if only the filename is listed i can use "-" as the token:
EG
artist1 - title1.mp3
artist2 - title2.mp3
rather than
time date size,000,000 artist1 - title1.mp3
and so on
thx!
edit: i dew apologize, i've just discovered the /b switch
Facebook
Twitter