Populating a new column with current date in a csv file

[zimmermand]

I have a csv file that currently has 3 columns and over 7000 rows. I need to create populate a 4th column with the current date (ex: 02/09/2015) for all of the rows. Any help is appreciated.

[Squashman]

assuming your date variable is in this format.

Code: Select all

H:\>echo %date%
Mon 02/09/2015

You can use this.

Code: Select all

@echo off
set tdate=%date:~4%

FOR /F "delims=" %%G IN (myfile.csv) DO >>newfile.csv echo %%G,%tdate%

There are ways to make the date regional independent should it be in a different format.

[zimmermand]

This worked...thank you. I am very new to scripts and now need to do this for a 2 column csv. Is it the 4% that tells it to put it in the 4th column?

[zimmermand]

Disregard my 2nd reply...it works great! Thank you.