Hi all,
Pls help me with file editing using awk.
I have a text file with the below format.

"STANDARD VOLUME ","2009","BUX","V","JCBH49","NF", 001413
"VENDOR MATERIAL-STD ","2009","BUX","V","JCBH49","NF", 009948
"INBOUND TRANS-STD ","2009","BUX","V","JCBH49","NF", 000264
"DIRECT LABOR-STD ","2009","BUX","V","JCBH49","NF", 000010
"VARIABLE BURDEN-STD ","2009","BUX","V","JCBH49","NF", 000062
"FIXED BURDEN-STD ","2009","BUX","V","JCBH49","NF", 000081

Here I want to retrieve the records of only "VENDOR MATERIAL-STD "and write to another text file. Also I want to replace "V" with “Prod Matl Cost PU Base Vehicle” and "O" with “Prod Matl Cost PU Avg Option” while writing to another file.

Thanks in advance.

try:

Thanks Yogesh.

I tried the below and got the below message.

#!/bin/ksh
sed -n -e '/VENDOR MATERIAL-STD / { s/"V"/Prod Matl Cost PU Base Vehicle./ ; s/"O"/.Prod Matl Cost PU Avg Optio
n./ ; p }' /clocal/fme/essbase/data/cash/goldbooklesspowertrain.txt > /clocal/fme/essbase/data/cash/newgoldbooklesspowertrain.
txt

Message:

sed: command garbled: /VENDOR MATERIAL-STD / { s/"V"/Prod Matl Cost PU Base Vehicle./ ; s/"O"/.Prod Matl Cost PU Avg Option./ ; p }