Read comma delimited .txt file with large number of data - do search in column A

Hi

I have a dataset from the stockmarket. It's intraday data so there are many inputs for each date.

I am trying to create only one row of daily data for each new day, so I need to find the range for each date, then get some values from this.

If you're familiar with stockmarkets, basically I have intraday-data and need to build a new .txt file (or .csv) with end-of-day data.

I know how to do this in VBA, but it would take a couple of weeks to get the work done...

If anyone would care to help me I would appreciate it.

Here's an example on how my .txt data look:

1/3/2012,09:30:00,409.3,410,409,409.79,6579011/3/2012,09:35:00,409.79,411.5,409.72,411.29,4937431/3/2012,09:40:00,411.3,411.68,410.63,410.86,3354201/3/2012,09:45:00,410.84,411.47,410.71,411.28,2120071/3/2012,09:50:00,411.28,411.5,410.85,411,2061541/3/2012,09:55:00,411,411.3,410.92,411.3,1414471/3/2012,10:00:00,411.3,411.75,411.11,411.65,2302471/3/2012,10:05:00,411.65,412,411.58,411.86,2000341/3/2012,10:10:00,411.89,412.2,411.57,411.76,2210071/3/2012,10:15:00,411.79,412.2,411.78,412.1,1111591/3/2012,10:20:00,412.1,412.41,412.08,412.4,1171931/3/2012,10:25:00,412.37,412.5,411.93,412.22,1471141/3/2012,10:30:00,412.22,412.38,411.9,412.03,914611/3/2012,10:35:00,412,412.08,411.8,411.92,1230931/3/2012,10:40:00,411.9,411.98,411.1,411.17,1458731/3/2012,10:45:00,411.17,411.33,410.56,410.68,1955391/3/2012,10:50:00,410.66,410.86,410.22,410.75,203342
I'm not experienced in C#, so I need pretty detailed information I think http://www.barakasoft.com/script/For...miley_wink.gif

Kind regards
Espen