Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-16 Thread Mark Knecht
I'm mostly the same way myself. The data was provided to me in a CSV file which made me think about spreadsheets. I really didn't expect to get an answer when I wrote the Open Office user's list but the response I got was very detailed and probably took me less time to do implement what I asked abo

Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-16 Thread Albert Hopkins
On Fri, 2007-11-16 at 05:28 -0800, Mark Knecht wrote: > Thanks for all the answers. They were interesting. Actually your answer was the most interesting. As a programmer, I'm always looking for a programmatic way of solving such problems. I would have never thought of using a spreadsheet (I onl

Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-16 Thread Mark Knecht
On Nov 15, 2007 5:58 PM, Philip Webb <[EMAIL PROTECTED]> wrote: > 071115 Mark Knecht wrote: > > I have a data file with data that changes infrequently. > > The file lists only the day the data changes. > > There are only 144 lines representing 23 years of data. > > There are three values for the da

Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-15 Thread Philip Webb
071115 Mark Knecht wrote: > I have a data file with data that changes infrequently. > The file lists only the day the data changes. > There are only 144 lines representing 23 years of data. > There are three values for the data - 1, 0 & -1. The file looks like this: > 09/27/74, 1 > 07/11/75,

Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-15 Thread Arturo 'Buanzo' Busleiman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 I'd read the whole file into a 2-field array, then just fill-in the gaps until the next value-change (value being the 2nd column). - -- Arturo "Buanzo" Busleiman - Consultor Independiente en Seguridad Informatica Apoye la Musica Libre - Vote Futura

Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-15 Thread Mark Kirkwood
I'd use something like perl[1] to read (2 lines initially) and then each line of the original file, generate the intermediate lines by comparing each line to the one before... printing the new generated lines to stdout (or a specified file if desired). Cheers Mark [1], perl, php, python, awk

[gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-15 Thread Mark Knecht
Hi, I know this is EXTREMELY off topic but I don't know of another better list to ask on. I'm hoping maybe there is a Linux command line method for doing this. Thanks in advance. I have a data file with data that changes infrequently. The file lists only the day the data changes. There are o

Re: [gentoo-user] VERY OFF TOPIC - change sparse data to daily data

2007-11-15 Thread Albert Hopkins
On Thu, 2007-11-15 at 14:25 -0800, Mark Knecht wrote: > Hi, >I know this is EXTREMELY off topic but I don't know of another > better list to ask on. I'm hoping maybe there is a Linux command line > method for doing this. Thanks in advance. > >I have a data file with data that changes infr