How do I create a batch file to create a csv/txt file that can be pulled into excel with the parent folder name as one column and the file name as another column

dir /s/b > output.txt

will produce a file with foldernames.

with VB you could read each line  in,  split on "\"  and you would know the last item is the filename and the rest is the directory.

the file scripting object can write to and output file for you.

saw this tool too:

http://www.avlandesign.com/filelist.htm

I've got the Dir output part, but am not familiar with VB. Do you have any examples I can pull from?

samples here:

http://www.activexperts.com/activmonitor/windowsmanagement/adminscripts/other/textfiles/

I dump the output to a text file, read it in with FSO.  use the readline() option and use the VB split command.

Code for splitting..

Dim myar() As String
Dim NewString As String 
file = "c:\test\one\two\three.txt" 
myar() = Split(file, "\") 
NewString = Left(file, InStrRev(file, "\")) & "," & myar(UBound(myar)) 
MsgBox NewString

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

looks good we'll try it in the morning and get back with you.

Try this.  Copy the bold lines below into a batch file, say DIRCSV.BAT.  Then just run it and pass it the name of the directory to list files in, and pipe the output to you desired results file.  So something like:

dircsv c:\temp > results.csv

~bp

@echo off
echo "Directory","File"
for /R "%~1" %%f in (*.*) do echo "%%~dpf","%%~nxf"

Billprew,

I think we're super close. Here's what we have in a batch file called list1.bat

@echo off
echo "Directory","File"
for /R \\server1\info\_it_stuff\multimedia\audio\clips %%f in (*.*) do echo "%%~dpf","%%~nxf" > results.csv

I'm not sure that I understand your above part:            dircsv c:\temp > results.csv

I tried using the "%~1" but the file errors so I changed it to the path instead.

The only issue we have now, is that the results.csv file contains only the last file in the directory along with its path (instead of the complete list). There are 2 columns (which are correct), but I'm missing something on the output part. I know we're close and it's probably something easy I'm missing.

Thoughts?

Okay, you need to correct the LIST1.BAT file and remove the changes you made compared to what I suggested.  It should only be:

@echo off
echo "Directory","File"
for /R "%~1" %%f in (*.*) do echo "%%~dpf","%%~nxf"

Them to run it at a Windows Command Prompt just enter the following in after the command prompt:

list1 \\server1\info\_it_stuff\multimedia\audio\clips > results.txt

In the code I supplied that you put in the LIST1.BAT file, the "%~1" will pick up the first parameter that you specify when you run the batch file.

Let me know if this doesn't clear things up.

~bp

BP,
You are the man. I now understand. You're actually calling the list1.bat file and telling it where to output the information via cmd line. It works now. Since we're this far into it, can I modify the list1.bat to list both the current folder and child folders/files in the same manner and only include certain file types? And how would I make this show only the folder the file resides in instead of the complete folder path?
If the last part's a major deal, than I won't worry about it as much

BP,
I figured out everything but listing only the folder name instead of the entire directory. Nevermind the other questions.

For others, I was looking only for .exe files, so changing the original

for /R "%~1" %%f in (*.*) do echo "%%~dpf","%%~nxf"
to
for /R "%~1" %%f in (*.exe) do echo "%%~dpf","%%~nxf"

only finds the exe s. The other issue with the folders was just because I deleted all the subfolders out of the parent folderso there were none to find...stupid me.

So you just want to list the parent folder name?

SETLOCAL ENABLEDELAYEDEXPANSION
for /R "%~1" %%f in (*.exe) do (
    Set DrivePath=%%~dpf
    for /f "tokens=*" %%g in ("!DrivePath:~0,-1!") do echo "%%~nxg","%%~nxf"
)

                                              

1:
2:
3:
4:
5: