Shell Programming and Scripting

Use global substitution...

awk '{gsub (/0108/,"2008"); print }' infile > outfile

white its working fine when i hardcode the values 0108/ with 2008..but i do not know which year will come in the wrong format...it may be 0109 or 0199 or anything...i need to search like for the 0***/ pattern i.e the year get the last two char and depending on it i need to replace it with the corresponding year...
for eg i get 0109/ i need to replace with 2009...
in the next line i may get 0110/ i need to replace with 2010...

so how to go about it ??

ok i can do like this for 0108/
but if i need to replace for 0109/ , 0110/.....0199/ ????

i need to put this in a loop and check the last two digits of the 0***/ and replace it with the corresponding year...
My question is can i use"$" variables inside awk'.....' ???? like awk '{gsub (/0$i/,"20$j")....' ????

If your file has a always the same format you can try this command:

Code:

$ echo '00000000 0 +00000000.00 2008/12/29 11:06:04 0108/12/29 10:05:37 00521363'| awk '{sub("01", "20", $6)}'1
00000000 0 +00000000.00 2008/12/29 11:06:04 2008/12/29 10:05:37 00521363

Regards

In this awk '{sub("01", "20", $6)}'1 ...what is that 1 stand for ???

awk evaluates the 1 as true and the prints the entire line by default.

Regards

Thanks a Lot Franklin!!! It worked....:-)