Shell Programming and Scripting

HI Folks,
I know the solution to my question is very easy but i could not find it out.

There is CSV file with 20 fields with 5 rows contains different data as below:

FBINV,LVO71,GAMFR1,D,104164,16677.36,20090625,102135,20090529,7267,KG,,,,0,,,,DTD,,O,O,,,,,,,,,30058 8136
FBINV,LVO71,GAMFR1,D,104164,16677.36,20090625,102135,20090529,7267,KG,,,,0,,,,DTD,,O,O,,,,,,,,,30058 8136
FBINV,LVO71,GAMFR1,D,104164,16677.36,20090625,102135,20090529,7267,KG,,,,0,,,,DTD,,O,O,,,,,,,,,30058 8136
FBINV,LVO71,GAMFR1,D,104164,16677.36,20090625,102135,20090529,7267,KG,,,,0,,,,DTD,,O,O,,,,,,,,,30058 8136
FBINV,LVO71,GAMFR1,D,104164,16677.36,20090625,102135,20090529,7267,KG,,,,0,,,,DTD,,O,O,,,,,,,,,30058 8136


I want to replace KG with K in field 11th in all the rows.

Can you please help me with a code to replace it in all the lines.processing line by line.There can be any number of rows in a file.


thanks a lot

Try this.

awk 'BEGIN { FS=OFS="," } /KG/ { $11 = "K" ; print }' filename

sed 's/,KG,/,K,/g' <input-file>

Code:

 
I want to replace KG with K in field 11th in all the rows.

None of the solutions from jayan_jay or lathavim are checking for the 11th filed.

Bit change to lathamvim's solution :

Code:

awk 'BEGIN {FS=OFS=","} $11 ~/KG/ { $11 = "K" ; print }'  File_name.txt