Author: Normand M. Blais
Date: 12:25:26 08/10/04
Go up one level in this thread
On August 10, 2004 at 14:57:38, Ray Banks wrote: >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 Hi Ray, The easiest way is to use a spreadsheet program like "Excel". Regards, Normand
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.