Windows 7 Forums Search
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows 7. The Windows 7 forum also covers news and updates and has an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7 - Help required creating batch file to read .csv file

 
02-02-2012   #1


Windows 7 Pro SP1 64-bit
 
 

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?

Regards,
JDobbsy1987

Attached Files
File Type: rar output.rar (209 Bytes, 13 views)
My System SpecsSystem Spec
Reply

 Help required creating batch file to read .csv file problems?



Thread Tools



Similar Threads for: Help required creating batch file to read .csv file
Thread Forum
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
How to create a batch file that will move files based on the file type General Discussion


All times are GMT -5. The time now is 02:20 AM.



Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30