Shell Programming and Scripting

Hi

I have file like below has many rows with different dates and ids.


ID FIRST_DT SEC_DT
111 2005-10-02 2010-10-01
222 2007-11-01 2040-09-13

I need to generate rows first_dt increment + 1 year until the SEC_DT year matches ,ID and sec_dt stays same ,here is the example below.

ID FIRST_DT SEC_DT

111 2005-10-02 2010-10-01
111 2006-10-02 2010-10-01
111 2007-10-02 2010-10-01
111 2008-10-02 2010-10-01
111 2009-10-02 2010-10-01
111 2010-10-02 2010-10-01

can you please help with this.

Thank you for your time.

nawk -f grepMe.awk myFile

grepMe.awk:

Code:

BEGIN {
    SEPdate="[ -]"
}
{
    n=split($0, tmpA, SEPdate)
    yStart=tmpA[2]
    yEnd=tmpA[n-2]
    for(i=yStart; i<=yEnd;i++) {
        sub($2, i, $2)
        print
    }
}

Hi

i have tested the script it is just printing the year YYYY only, can you help print month and date as well.

awk -f script.awk input_file.txt

here is the output from my testing.

1111 1999 2010-01-01
1111 2000 2010-01-01
1111 2001 2010-01-01
1111 2002 2010-01-01

thanks in advance.
Pimmit

Not tested but try this:

Code:

awk  '{

split ($2, LowerDate, "-")
split ($3, UpperDate, "-")
print 
 for(i=LowerDate[0]; i<=UpperDate[0]; i++) {

NewDate= sub( LowerDate[0], i, $2 )
print $1 NewDate $3
    }
}' Filename

it did n't run it says syntex error with script.

what is the filename at end of the script.

awk -f script.awk input_file.txt

File name is the absolute path of the file that has data in it.

or try this code:

Code:

{

split ($2, LowerDate, "-")
split ($3, UpperDate, "-")
print 
 for(i=LowerDate[0]; i<=UpperDate[0]; i++) {

NewDate= sub( LowerDate[0], i, $2 )
print $1 NewDate $3
    }
}