Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide 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 Feb 2012   #1

Windows 8.1 Pro x64
 
 
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, 39 views)
My System SpecsSystem Spec
.

Reply

 Help required creating batch file to read .csv file





Thread Tools



Similar help and support threads for2: Help required creating batch file to read .csv file
Thread Forum
Serial read/write in batch file? General Discussion
Solved Batch File that grabs file names from folder to insert into batch file General Discussion
Solved 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

Our Sites

Site Links

About Us

Find Us

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

All times are GMT -5. The time now is 01:07 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

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 31 32 33