Please help, creating DOS batch file to create csv from DIR

Message

aown61 · #1 Post by **aown61** » 02 Sep 2010 01:20

Hi guys i've created the below batch file to create a csv fil from a dir command.

@echo ImageId, ImageFilePath >> "\\ptdckbox01\d$\Bi Projects\Inputs\RE\Audit_Pics\audit_pics_dir.csv"
dir "\\ptdckbox01\d$\Bi Projects\Inputs\RE\Audit_Pics\" /b /s >> "\\ptdckbox01\d$\Bi Projects\Inputs\RE\Audit_Pics\audit_pics_dir.csv"
exit

which outputs like this

this is fine but i need to make it look like this...

Any suggestions? I just cant work out how i can call the same DIR and kind of concat it to the output .csv

If you can help you will be a life saver!
Regards
-Andy

orange_batch · #2 Post by **orange_batch** » 02 Sep 2010 02:43

There may be a better solution, but based on your code (btw there is spacing discrepancy which I'm sure you know)...

Code: Select all

@echo ImageId, ImageFilePath >> "\\ptdckbox01\d$\Bi Projects\Inputs\RE\Audit_Pics\audit_pics_dir.csv"
for /f "delims=" %%x in ('dir "\\ptdckbox01\d$\Bi Projects\Inputs\RE\Audit_Pics\" /b /s') do (
echo %%~nxx,%%x>> "\\ptdckbox01\d$\Bi Projects\Inputs\RE\Audit_Pics\audit_pics_dir.csv"
)
exit

Not tested. I don't know if FOR works fine on network locations, but to be safe it's parsing the line as a string. Luckily ~nx (enhanced references) works on strings too.

aown61 · #3 Post by **aown61** » 02 Sep 2010 03:14

You sir are a genius!
Thank you very much, exactly what i was after

-Andy

orange_batch · #4 Post by **orange_batch** » 02 Sep 2010 03:25

DosTips.com

Please help, creating DOS batch file to create csv from DIR

Please help, creating DOS batch file to create csv from DIR

Re: Please help, creating DOS batch file to create csv from

Re: Please help, creating DOS batch file to create csv from

Re: Please help, creating DOS batch file to create csv from