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?
Regards,
JDobbsy1987