I need to read (and overwrite) a selected group of .csv files, taken over a 24
hour period. The files have the following structure:
<1st File>
Some Lines
of Header
Run#, Date, Time, Points, Engine Speed, .......
_, _, _, Averaged, r pm, .......
35, 10/30/2008, 00:16:34.017, 1, 700.8, .......
35, 10/30/2008, 00:16:34.038, 1, 701.3, .......
... [= thousands of rows]
35, 10/30/2008, 23:59:59.988, 1, 1227.1, .......
<EOF>
<Next File>
Some Lines
of Header
Run#, Date, Time, Points, Engine Speed, .......
_, _, _, Averaged, rpm, .......
35, 10/31/2008, 00:00:00.007, 1, 1227.0, .......
35, 10/31/2008, 00:00:00.027, 1, 1226.6, .......
... [= thousands of rows]
<EOF>
& so on.
I need to replace the "Points Averaged" column with "Elapsed seconds", and,
starting with the first data-row as "0.000" (in that column), conclude the
last file with something like "87304.714". Everything else is done but, the
Date functions truncate off the decimals, and I can't seem to get TimeSpan
working at all - so I need help. I'm using VB2005Pro.
