So here's the problem: My Friends program shoots out data into a text file every 10 seconds, but I only need the data every minute which leaves me with 6 times the data I need. The data is set up in the .txt file to be converted into a CSV(comma seperated values) by MSExcel.
A .txt file in CSV format looks like this:
Code:
1,1
2,2
3,3
4,4
5,5
6,6
Excel will take that information and convert
into
So Before I convert the file I need to figure out how to delete lines 1-5 but not 6
Ex:
Code:
1,1 = Delete
2,2 = Delete
3,3 = Delete
4,4 = Delete
5,5 = Delete
6,6
HOWEVER, they are not conveniently numbered like that, or so with little text
Expect something like:
Code:
91.8,30.4
961,178
1832,1039
123,18.137
1241,18247.2
1264,1284
123,172.1284
1274,1263.1298
1283
12812, 12364
980, 1248901
98435,127.2
etc... probably at least 200+ lines
In that example I would need "1264,1284" and "98435,127.2".
Let's assume Text wrap is off and we are only dealing with numbers.
My Ideas.
1) I haven't actually seen the whole file yet so lets assume there is no obvious start and end point
Code:
[start]1,1[stop]
I wish...
2) I don't think I can access the file while it's being written, unfortunately that would have made it a lot easier.
3)Maybe I could have Scar start from the top then find how long the characters the line had then use delete until the sixth line, then down arrow 2 times then start again, But I don't know how I would find how many characters in the line using just the position of the bar thingy(the thing that blinks in front of the text you're writing
) or even locate it in the first place
4)Count commas, I could probably do that myself with scar, maybe even with a bitmap.
5) It also has to be very objective to work from anywhere, with no user input.
If you have any questions please ask.
I thank you in advance for All Ideas/Help/Noob posts to increase post count 
EDIT: I don't want to double post so here's some more info, i just got
It will look more like this
IGNORE LINE NUMBERS THEY CORRESPOND TO EXCEL ROWS
remember, the comma's become
Code:
1: TIME, TC[i], ( If you can't figure out a way to the delete the whole line, regard I as a variable from 1-100)
2 to about 10: (Contains useless info must be deleted)
11+: 7:30:11, 2.4, 2.2 (Each new row has a Time stamp, the amount of columns after corresponds to the amount to TC's)
NEW IDEA: I might be able to read the Time Stamp which will help a lot.
For example, if the first stamp is 7:31:13, then I would delete until 7:32:13.