Hi All,

My requisite is to search for the string "0108"(which is the year and has come in the wrong year format) in a particular column say 4th column in a tab delimited file and then replace it with 2008(the correct year format) in the same position where 0108 was found..The issue is the last two digits in "0108" tells the year..The file may contain "0109","0110" and so on...i need to replace the correct year depending on the last two digits of the string..How do i go about??please help me....

eg

00000000 0 +00000000.00 2008/12/29 11:06:04 0108/12/29 10:05:37 00521363

i need to change this to

00000000 0 +00000000.00 2008/12/29 11:06:04 2008/12/29 10:05:37 00521363

Thanks in advance!!!

use this...

awk '{sub (/0108/,"2008"); print }' infile

This is not working whiteboard.....it jus replaces the string and displays since print statement is given in AWK.... i need to replace in the actual file itself.....

Redirect it to a new file..

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

The file contains many numerical values ...so there may be many places where 0108 occurs...i need to find the string 0108/ and search it with 2008...how to do it white???