|02 Feb 2012||#1|
| || |
Help required creating batch file to read .csv file
As always, when help is required i find myself here (because SevenForums is AWESOME!)
As the title suggests, i would like to use a batch file to read the contents of a .csv file, i will try to explain the best i can and attach an example file.
So... I have exported a list of users from a system into a .csv file, this file contains the date the users were created and the name of the users.
I would like the batch file to read the date created column and where the date is within the last 7 days i would like to copy the users name into a .txt file (e.g. c:\logs\7days\output.txt)
The date is in date and time format like this: yyyymmddhhmmss
I don't care about the hhmmss, i just want to look at the date and see if it is within the last 7 days.
I have attached an example output.csv file (attached as a .rar file) if it helps
Can someone please help me out with this?
|My System Specs|
|Similar help and support threads for2: Help required creating batch file to read .csv file|
|Serial read/write in batch file?||General Discussion|
|Batch File that grabs file names from folder to insert into batch file||General Discussion|
|Creating Batch File with Robo Copy||General Discussion|
|Help creating a batch file to auto login to a website||General Discussion|
|Help Needed Creating Batch File||General Discussion|
|Help creating batch file||General Discussion|
|Creating a welcoming batch file...||Software|