linux.gentoo.user

On Nov 15, 2007 5:58 PM, Philip Webb 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 data - 1, 0 & -1. The file looks like this:
> > 09/27/74, 1
> > 07/11/75, -1
> > 08/01/75, 1
> > 03/12/76, -1
> > 04/02/76, 1
> > 05/07/76, -1
> > 06/04/76, 1
> > I need to turn this data into a file with the same format
> > but one that has data for every date, something like this:
> > 09/28/74, 1
> > 09/29/74, 1
> > 09/30/74, 1
>
> I would do it with Vim, mainly 's' & 'q'. It would probably help slightly
> if you used international date format: '1974-09-27' etc. HTH
>

Thanks for all the answers. They were interesting.

After I wrote to this group I wondered if there was a way to do this
in Open Office so I wrote to t. Turns out in the Calc there is a
simple function called VLOOKUP. Put the original table in one area,
create a long list of dates from 1974 through present in another area
and have VLOOKUP find the right date and value. The whole process took
about 5 minutes once I was directed to the functions.

Again, I appreciate the responses.

- Mark
--
gentoo-user@gentoo.org mailing list