Batch file to output filename to csv file Solved/Closed

Question

Hello,

I'm looking to write a windows batch file that will look for a fixed file in a fixed folder (ie c:\folder\file1.csv) and use the dir command to output the filename and last written date to a second csv file (ie c:\folder\file2.csv).  The output must be in two columns and will look something like this when you open file2.csv:

file1.csv      10/14/2008 15:38


This seems like a fairly straightforward batch, but i'm struggling to limit my output to just these two attributes and place them in the first two columns and first row of  file2.csv

Any help would be greatly appreciated. Thanks!!!

Swarve · Accepted Answer

Hi CP1717,

The script you need is as follows:

____________________Begin Code__________________


Dim Filepath
Dim Filename
Dim OutputFile

Filepath = "c:	est\"		'Edit this to specify the filepath
Filename = "file1.csv"		'Name of file that last edited date/time is needed
OutputFile = "file2.csv"	'File to output results to

Set objFSO = CreateObject("Scripting.FileSystemObject")
If not objFSO.FileExists(FilePath & OutputFile) then 
	Set objFile = objFSO.CreateTextFile(Filepath & OutputFile)
	Wscript.sleep(2000)	'Pause while file is being created
End If


If objFSO.FileExists(Filepath & Filename) then
	Set objFile = objFSO.GetFile(Filepath & Filename)
	Lastmodifieddate = objFile.DateLastModified

	Const ForWriting = 2
	Set outputFile = objFSO.OpenTextFile(Filepath & "file2.csv", ForWriting)	' Open file for writing
	OutputFile.Write Filename & "," & objFile.DateLastModified 		 	'Write filename and last modified date to output file
	OutputFile.Close
End If
set objFSO = Nothing


____________________End Code__________________


The three variables, filepath, filename and output file that are set up on lines 5, 6 and 7 can be modified to pick up any path and filename that you specify and will create the file on line 7 on the same path.

If you save that code as test.vbs file, then in your batch file, you will need to enter the line "Call test.vbs".  Obviously if you change the name of the vbs file, you will need to change the reference to it in your batch file.

Bandy (now known as Swarve since I've joined)

Bandy · Answer

Hi CP1717,

Does the script have to be in a batch file?  You might be better off using a vbs file to get the properties of the file1.csv and output them to file2.csv.

If you need the vbs script written, I should be able to come up with it for you.  You can always call this script from within a batch file so it won't detract from any other scripts you already have written.

Swarve · Answer

Oops, I just noticed something that I should have changed when I set up the second filename as a variable.

On line 21 (Set outputFile = objFSO.OpenTextFile(Filepath & "file2.csv", ForWriting) ' Open file for writing)

The text : 
& "file2.csv", 

should be changed to: 
& Outputfile,

I was a little overzealous in testing it then posting unfortunately.

Cheers, Swarve

Richard.Williams · Answer

Excellent vbscripts so far. Here are some possible alternatives. CP1717 said, > I'm looking to write a windows batch file that will look for a fixed file in a > fixed folder (ie c:\folder\file1.csv) and use the dir command to output the filename > and last written date to a second csv file (ie c:\folder\file2.csv). > The output must be in two columns Probably will need only one biterscripting command. echo "c:/folder/file1.csv" "," { af -m "c:/folder/file1.csv" } >> "c:/folder/file2.csv" The af command is for "access file attributes". Use forward slashes in path. Also I recommend using a TSV (Tab separated values) instead of CSV. What if the file name contains a comma ? 00666111384 asked, > How can make a vbs file is it the same as creating a batch file? > I wanna know how to make my html file change it extension name to .txt > files with date included. > > example: > > ren *.html -> 02-20-2009 *.txt One command again. system rename ("\""+"c:/folder/xyz.html"+"\"") ("\""+{ af -m "c:/folder/xyz.html" }+"xyz.txt"+"\"") You can also do this for all files in a loop with the biter script below. var str list, file, newname lf -n "*.html" "C:/folder" > $list while ($list <> "") do lex "1" $list > $file stex -p "^/^l[" $file > $newname ; stex "[^.^l" $newname > null set $newname = { ad -m $file }+$newname+".txt" system rename ("\""+$file+"\"") ("\""+$newname+"\"") done All biter scripts you can call from batch.

Batch file to output filename to csv file

4 responses

Similar discussions

Subscribe To Our Newsletter!