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 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 -- [EMAIL PROTECTED] mailing list
