Forum Moderators: phranque

Message Too Old, No Replies

Help For Extracting Multiple File Names

         

Cza102282

10:57 pm on Aug 28, 2009 (gmt 0)

10+ Year Member



I am putting together a radio show and I have started gathering all of my .mp3 files into one directory. I would like to be able to extract the file name of each so I don't need to go through an unnecessary typing exercise when placing them in my SQL database. Is there a way to copy all of the names into windows clipboard?

Any suggestions?

tangor

1:16 am on Aug 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



run/command cd to folder

dir * /s > filename.txt

The /s is only if there are subfolders beneath

Cza102282

3:50 pm on Aug 31, 2009 (gmt 0)

10+ Year Member



Thanks. That is very useful.

At first glance it seems that the .txt file created records more than just the file name. I may have to use some creative "find/replace" in word or excel.

Terabytes

3:58 pm on Aug 31, 2009 (gmt 0)

10+ Year Member



you can use dir *.* /s /b

the /b gives you a bare format... just filenames...
you can also do

dir /?

This will show you a list of options for the output for the directory query..

That should help...