Reading in data from text files

IN PROGRESS
Bids
40
Avg Bid (USD)
$94
Project Budget (USD)
$30 - $250

Project Description:
We have text files that contain hourly data on traffic volume on a highway. Each file covers a year's worth of data and we have 10 such files. The text file is organized as a vertical stack of weekly reports. Each report has a header identifying the week, location, data source etc and so the headers are largely repititive. Of interest are the hourly counts which are presented below the header. The columns represent individual dates and the rows represent hours (24 rows in all.) The row labels identify the hour (e.g. "1-2") and the column labels identify the date (e.g. "FEB 18"). Each report ends with a footer that has various summary statistics. Sometimes, the hourly data are missing (blank) and usually the hourly data number is followed by a letter (e.g. "A") which denotes the relevant stretch of the highway. We only care about the hourly traffic volume number for each date in the data. We would like a clean text file that has 3 columns: date (ddmmyy), hour, traffic volume.

Additional Project Description:
10/10/2010 at 6:56 NZDT
The weekly reports can come from different locations (traffic stations) for the same week. We would like to keep track of the traffic station number and the number of lanes (also in the header.) Therefore the final product should have: date, hour, traffic station number, lanes, traffic volume.

Skills required:
C Programming, C++ Programming, Perl
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 0 days
$ 80
in 0 days
Hire Mindon
$ 120
in 3 days
$ 100
in 2 days
$ 250
in 7 days
Hire deadhunt
$ 50
in 1 days
$ 180
in 3 days
Hire zeke
$ 100
in 1 days
Hire Wonderer
$ 125
in 2 days
Hire CatBasil
$ 100
in 3 days