awk substitution help

[lawrenzo_1]

ok thanks James

[Hein van den Heuvel]

Chris>> Hein this works but there are months from 2006 with the time stamp (oct,nov,dec)

Yes. Duh. What was I thinking?

Ultimately you'll be better of picking up perl, specially for easy jobs to learn, but just to correct my bad advice her it an awk variant:

awk '{filename=$9; month=$7; year=$8; if (year ~ /:/){year = (month ~ /Sep|Oct|Nov|Dec/)? 2006 : 2007} print filename,month,year}' orig

In slow motion...

awk '{
filename=$9;
month=$7;
year=$8;
if (year ~ /:/){
year = (month ~ /Sep|Oct|Nov|Dec/)? 2006 : 2007
}
print filename,month,year
}' orig

Hein

[lawrenzo_1]

great stuff thanks all!

Chris.

[lawrenzo_1]

;)