Computer Chess Club Archives


Search

Terms

Messages

Subject: O/T - Programming assistance

Author: Ray Banks

Date: 11:57:38 08/10/04


My limited programming knowledge is so old that this will take me hours, but I
know some of you here could do it in 5 mins.

I need to prompt for a file to read in, (a comma delimited text file), calculate
an additional column, and prompt to write back to a new file. I know it is
probably a matter of reading the file into an array, calculating and adding the
extra column with a do-loop, then outpiutting it, but I've forgotten how. I also
don't have any programming languages currently installed.

The input file is like this:

1,"35000/001",1/1/2002,06:00:00
2,"35000/001",5/2/2003,07:00:00
3,"35000/001",6/1/2004,07:00:00
4,"35000/002",3/9/1999,05:32:00
5,"35000/002",5/4/2004,04:34:00
6,"35000/003",4/1/2003,07:12:00
7,"35000/004",5/5/2001,12:34:00
8,"35000/004",3/2/2002,17:30:00
9,"35000/005",9/7/2004,12:32:00

and the output file would be

1,"35000/001",1/1/2002,06:00:00,1
2,"35000/001",5/2/2003,07:00:00,2
3,"35000/001",6/1/2004,07:00:00,3
4,"35000/002",3/9/1999,05:32:00,1
5,"35000/002",5/4/2004,04:34:00,2
6,"35000/003",4/1/2003,07:12:00,1
7,"35000/004",5/5/2001,12:34:00,1
8,"35000/004",3/2/2002,17:30:00,2
9,"35000/005",9/7/2004,12:32:00,1

The new last column is basically a counter, which is re-set upon a changed value
in the second column.

I know it is asking a lot, but I'd be really grateful if someone could give me
some assistance on this

many thanks
Ray







This page took 0 seconds to execute

Last modified: Thu, 15 Apr 21 08:11:13 -0700

Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.