I'm working with a windows batch script to create a list of filenames and filepaths in a CSV format for parsing of reports by a document management application. I need to have the path to the file and the actual file name (by itself) to be used as an index value (the application looks up the filename in a SQL DB and brings in the remaining index information). Ideally I'd like to be able to just call a VBScript that will perform the operation as part of the batch process that will run daily.
I've already used DIR commands and another VBscript to produce two files that I will need to combine into a CSV, filelistA.txt and filelistB.txt:
filelistA.txt looks like:
filelistB.txt looks like:
I want to make FileListCSV.txt, that looks like this:
Thanks in advance for your help.