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