Need to create a list of files and pathnames for a directory and output to TXT file

Note that in the above batch file, there is a TAB in between  %%~nF  and  %%F.

Also, you will need to change the drive and folder to match your files.  ( such as O:\Clients  ;)

@echo off
O:
cd O:\Clients
for /f %%F in ('dir/s/b *.*') do @echo %%~nF      %%F>c:\output.txt

In the second version I removed the space between the %%F and the > so that it doesn't get put in the output file C:\output.txt

OOPS - there is a flaw in both of the above scripts, stand by -- correction posted below:

@echo off
O:
cd O:\Clients
for /f %%F in ('dir/s/b *.*') do @echo %%~nF%%~xF      %%F>c:\output.txt

again, there is a TAB in between  %%~nF  and  %%F

... I mean between  %%~nF%%~xF  and  %%F

Great, but I just found out I actually need another column in my output....the filename with NO extension. Can that be done?

Output would be:

<FILENAME.NOEXT>            <FILENAME>     <PATHNAME + FILENAME>
test                                         test.txt            c:\data\test.txt

Actuallly, I will also need the path name repeated with no file name:

<FILENAME.NOEXT>            <FILENAME>     <PATHNAME + FILENAME>          <PATHNAME ONLY>
test                                         test.txt            c:\data\test.txt                              c:\data

@echo off
O:
cd O:\Clients
for /f %%F in ('dir/s/b *.*') do @echo %%~nF    %%~nF%%~xF    %%F    %%~dF%%~pF>c:\output.txt

The output format is okay, but I do not show file extensions in the second column and third columns and it only outputted for a single file:

WIll    WIll    O:\Clients\4876\00083\WitnessDepos\WIll    O:\Test1\4876\00083\WitnessDepos\

To correct the single-line output, use >> instead of >

  for /f %%F in ('dir/s/b *.*') do @echo %%~nF    %%~nF%%~xF    %%F    %%~dF%%~pF>>c:\output.txt

Let me know how this works for you.

actually, you will want to start with a fresh output file each time, so do this:

@echo off
del c:\output.txt
O:
cd O:\Clients
for /f %%F in ('dir/s/b *.*') do @echo %%~nF    %%~nF%%~xF    %%F    %%~dF%%~pF>>c:\output.txt

still need >> instead of >

Not sure what you mean...do I need 2x ">" in the script?

Here is what I am using:

@echo off
O:
cd O:\Clients
for /f %%F in ('dir/s/b *.*') do @echo %%~nF    %%~nF%%~xF    %%F    %%~dF%%~pF>c:\output.txt

instead of:   >c:\output.txt
you need:  >>c:\output.txt

Hi KnightEknight,

For future reference, FOR variable modifiers are stackable.. So your command could be simplified as:
FOR /F %%F IN ('DIR /S /B *.*) DO @ECHO %%~nF      %%~nxF      %%F      %%~dpF>>C:\Output.txt

pb

Oops,

I should also mention that if you want to list only files and not directories, the DIR command should be modified to the following:
DIR /S /B /A-D

The other thing is that any files or directories with spaces in the name will not get output correctly unless you use a DELIMS to ignore the spaces.

So the full command should be something like this if run directly from the command line:
FOR /F "DELIMS=" %F IN ('DIR /S /B /A-D O:\Clients\*.*') DO @ECHO %~nF  %~nxF  %F  %~dpF>>Output.txt

Of course, the double spaces after the ECHO should be tabs.

pb

Changing the double spaces to tabs still does not put tabs into the output.txt. It puts spaces to mimic the tab.

I can't open the output.txt in excel specifying it being a tab delimited file.

Here's a VBS version to put in true tabs.

Const ForWriting = 2
StartFolder = "O:\clients"
TABFile = "C:\FileList.txt"
 
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTABFile = objFSO.OpenTextfile(TABFile, ForWriting, True)
 
Call CheckFolder(StartFolder) 
 
Set objFSO = Nothing
objTABFile.Close
 
Sub CheckFolder(Folder)
    Set arrfiles = objFSO.GetFolder(Folder).Files
    
    If objFSO.GetFolder(Folder).Files.Count <> 0 Then
        For Each File In arrfiles
            objTABFile.Writeline Left(File.Name, instrrev(File.name, ".") - 1) & vbTab & File.name & vbTab & File & vbTab & File.Path
        Next
    End If
 
    Set ArrSubFolders = objFSO.GetFolder(Folder).SubFolders
 
    For Each SubFolder In ArrSubFolders
        Call CheckFolder(SubFolder)
    Next
End Sub
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27: