THanks Jim. Eventually I do want to store the records in a database... so mySQL. But right now I want to run some analytics on the data so I'm looking for a quick and dirty solution that can give me the flexibility to extract data on various time periods. I think a perl script that uses Text:CSV_XS and Parse::CSV would be the best for now.... too bad I haven't ever programmed in perl.
I know in the end the perl script necessary to do what I want will turn out to be 15-20 lines of code but it is going to take me hours.... it has already taken me 5 hours just to learn about the modules and install them. Now I'm onto the task of how to use them and am having various problems parsing the fields. But I guess this is a good learning exercise. Thank you for the valuable comments. -- View this message in context: http://r.789695.n4.nabble.com/read-file-part-way-through-based-on-start-and-end-date-first-column-tp3391769p3392533.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.