How Do I Export Text File

[WyattWhiteEagle]

Using a cmd prompt, how do I export to my desktop a text file which list only the filename, type and location of all mp3 files on my computer?

How would I export to my desktop the same thing but listing what is on an external drive or a usb flashdrive?

How about a txt file which list all mp3 in a folders without reflecting the filepath?

Also, How would I export a txt file listing all mp3 files inside a certain folder and subfolders?

 

[mrjimphelps]

Type this command in the command prompt window:

dir c:\*.mp3 /s > c:\filelist.txt

This will do a directory listing on your entire C: drive, including all subdirectories, for all files which have .mp3 as their extension. It will direct the output of the command into a text file, c:\filelist.txt. Change the last part -- c:\filelist.txt -- to reflect the filename you want, in the subdirectory you want.

To do the same thing for your external drive or flashdrive, replace C: with whatever drive letter is used for that device.

I don't recall the switch you would use to get the filenames without the paths included, but I think it is /b. Go to a command prompt and type dir /? to get all of the information and options for the dir command.

If the switch is /b, then the above command would be changed as follows:

dir c:\*.mp3 /s /b > c:\filelist.txt

The /s switch tells it to do all subdirectories.

To get the listing for a certain folder and subfolders, let's say C:\My Music, do it like this:

dir "C:\My Music\*.mp3" /s > c:\filelist.txt

 

[WyattWhiteEagle]

What would be the cmdlet to have no more than one file name on one line in the text file?

If I have 20 files in a folder on the desktop and a subfolder containing an additional 20 files, I would like to have the exported text file use 20 lines listing all the files in the folder and 20 other lines for the subfolder.

 

[RolandJS]

I think the batch file will list one file one line - unless the full directory of each file is asked for. It has been a long while since I made and used batch-files.

 

[WyattWhiteEagle]

I think the batch file will list one file one line - unless the full directory of each file is asked for. It has been a long while since I made and used batch-files.

That is true.

I believe batch files use PowerShell. I have no problem using PowerShell, it's just I prefer using cmd.exe (Admin)

 

[WyattWhiteEagle]

How do I get the exported text file to not show the date, time and size of the files?
I only want the path and filename in alphabetical order one file for one line.

If I must settle with showing the date, time, and size, how can i have the filename to the far left and the rest after the filename?

ok, it is exporting a text file.

dir c:\Users\Wyatt\Desktop\*.mp3 /a /s list sortorder N > c:\Users\Wyatt\Desktop\MP3s.txt

When I open the file it shows one line one file.

Directory of [folder path]

date [tab] time [tab] size [tab] filename
date [tab] time [tab] size [tab] filename
date [tab] time [tab] size [tab] filename

Directory of [folder path]

date [tab] time [tab] size [tab] filename
date [tab] time [tab] size [tab] filename
date [tab] time [tab] size [tab] filename

I would like for it to look like this...

Directory of [folder path]

filename
filename
filename

or...

Directory of [folder path]

filename [tab] Date [tab] Size
filename [tab] Date [tab] Size
filename [tab] Date [tab] Size

As long as the filenames are to the far left

 

[Brink]

Hello Wyatt,

You could also use the command below to list the files in individual lines per directory.

dir c:\*.mp3 /s /o:gn > %UserProfile%\Desktop\filelist.txt

 

[WyattWhiteEagle]

Hello Wyatt,

You could also use the command below to list the files in individual lines per directory.

dir c:\*.mp3 /s /o:gn > %UserProfile%\Desktop\filelist.txt

View attachment 410662

Thank you so very much. I tweaked that a little...

dir %UserProfile%\Desktop\*.mp3 /s /o:gn > %UserProfile%\Desktop\MP3s.txt

The resulting export shows the filenames after the Date/Time and size.

Is it possible to create the export showing the full filenames before the Date/Time and size?

 

[Brink]

I'm not sure how without the filenames being on the same line instead of separate, or only a list of full file paths per separate line without date/time/size.

 

[WyattWhiteEagle]

I'm not sure how without the filenames being on the same line instead of separate, or only a list of full file paths per separate line without date/time/size.

Now I'm curious how the resulting export would display what you mention. May I have those codes to see if something like that is closer to what I'm looking for?

 

[Brink]

(File path list only)
dir %UserProfile%\Desktop\*.mp3 /s /b > %UserProfile%\Desktop\MP3s.txt

(Wide list format without individual file date/time/size)
dir %UserProfile%\Desktop\*.mp3 /s /w > %UserProfile%\Desktop\MP3s.txt

 

[WyattWhiteEagle]

dir %UserProfile%\Desktop\*.mp3 /s /w > %UserProfile%\Desktop\MP3s.txt

Using the above, the first is what is exported. The second is what I would like to see exported.
I opened and customized for this post.

If PowerShell is actually what I need to use, what would be the codes and how would I use them?

 Volume in drive C has...
 Volume Serial Number is...

 Directory of %UserProfile%\Desktop\Audio

(Garth Brooks) Double Live (Disc 1) [05] The Thunder Rolls (The Long Version) (10).mp3
(Garth Brooks) Double Live (Disc 1) [05] The Thunder Rolls (The Long Version) (14).mp3
(I Just) Died in Your Arms Tonight (2).mp3
(I Just) Died in Your Arms Tonight (3).mp3
               4 File(s)     23,865,532 bytes

 Directory of %UserProfile%\Desktop\Audio\Luke Bryan

Apologize.mp3                        Better Than My Heart.mp3
Country Girl (Shake It For Me).mp3   Crash My Party.mp3
Do I.mp3                             Drink A Beer.mp3

and so on...

              23 File(s)    162,264,912 bytes

 Volume in drive C has...
 Volume Serial Number is...

 Directory of %UserProfile%\Desktop\Audio

(Garth Brooks) Double Live (Disc 1) [05] The Thunder Rolls (The Long Version) (10).mp3
(Garth Brooks) Double Live (Disc 1) [05] The Thunder Rolls (The Long Version) (14).mp3
(I Just) Died in Your Arms Tonight (2).mp3
(I Just) Died in Your Arms Tonight (3).mp3
               4 File(s)     23,865,532 bytes

 Directory of %UserProfile%\Desktop\Audio\Luke Bryan

Apologize.mp3                        
Better Than My Heart.mp3
Country Girl (Shake It For Me).mp3

and so on...

              23 File(s)    162,264,912 bytes

 

[Brink]

I'm not sure it's possible to have mixed output formats like that.

 

[iko22]

Would it produce the desired format to use the /D switch in place of the /W, like:
dir %UserProfile%\Desktop\*.mp3 /s /d > %UserProfile%\Desktop\MP3s.txt

 

[WyattWhiteEagle]

Would it produce the desired format to use the /D switch in place of the /W, like:
dir %UserProfile%\Desktop\*.mp3 /s /d > %UserProfile%\Desktop\MP3s.txt

I'll try it now and post the results

 

[WyattWhiteEagle]

Would it produce the desired format to use the /D switch in place of the /W, like:
dir %UserProfile%\Desktop\*.mp3 /s /d > %UserProfile%\Desktop\MP3s.txt

Hmmm, using the /D switch in place of the /W switch seems to produce the same format

 

[WyattWhiteEagle]

I don't believe some of my switches are being redirected to other switches. Is that possible?

 

[iko22]

What makes you think that?

 

[WyattWhiteEagle]

I had that thought after considering the 2 switches are producing the same results

 

[iko22]

The only other format DIR can produce, is with the /D and /W omitted.