Shell Programming and Scripting

Hi
I have a flat file looking this

QWER 2:35 7044 00001 ROUT 1188 EA SS
ASD 2:36 7044 00010 ROUT
BSD 2:37 7044 00011 ROUT
END
QWER 3:35 7044 00011 ROUT 1088 EA SS
ASD 3:36 7044 00010 ROUT
BSD 3:37 7044 00011 ROUT
END

If the redcolor value is 1088 then i need to change the values in the 3rd column (ie., 7044) to 9999 . How do i do script in HP -UX

Thanks
Krishna

one mort thing one set of order starts with QWER & ends with END . so I do want to change to entire 3rd column between QWER to END


Thanks
KRishna

How about this?

Code:

awk '
    # if the QWER line contains 1088, set the change flag to true
    $1=="QWER" { if ($6==1088) { change=1 } else { change=0 } }
    # if the change flag is set and the line has more than 3 fields, override the 3rd value
    change && NF > 3 { $3=9999 }
    # print the line
    1
' inputfile

Code:

sed '/1188/s/7044/9999/g' filename

Thanks

That won't change the lines between QWER and END that do not contain 1088.

thanks alls. But Let me tell my requiremnet one more time .
QWER 2:35 7044 00001 ROUT 1188 EA SS
ASD 2:36 7044 00010 ROUT
BSD 2:37 7044 00011 ROUT
END
QWER 3:35 7044 00011 ROUT 1088 EA SS
ASD 3:36 sed '/1188/s/7044/9999/g' 00010 ROUT
BSD 3:37 7044 00011 ROUT
END
If the redcolor value is 1088 then i need to change the values in the 3rd column (ie., 7044) to 9999 . How do i do script in HP -UX

I want output as
QWER 2:35 7044 00001 ROUT 1188 EA SS
ASD 2:36 7044 00010 ROUT
BSD 2:37 7044 00011 ROUT
END
QWER 3:35 1088 00011 ROUT 1088 EA SS
ASD 3:36 1088 00010 ROUT
BSD 3:37 1088 00011 ROUT
END



Thanks
Krishna

Using awk

Code:

awk '$6 ~ /1[0-1]88/{$3=9999}1' data.file

or sed

Code:

sed  '/1[0-1]88/s/7044/9999/g'   data.file