Dear All,
I have a txt file which contains strings and numerical columns. Here are some samples of this txt file:
3 'CHSTRSVC' 345.00 2 0.00 0.00 1 1 1.0269 -11.382 1
4 'ORRINGTN' 345.00 1 0.00 0.00 1 1 1.0191 -16.365 1
3146 'ORRINGTN' 345.00 1 0.00 0.00 1 1 1.0162 -13.797 1
3147 'ORRINGTN' 345.00 1 0.00 0.00 1 1 1.0179 -13.586 1
……
I want to replace the values in the last 2 columns with updated values, and save the updated values in the same txt file. So the txt file has only two columns updated. For example, in the first row, I want to replace 1.0269 with 0.9987 and -11.382 with -10.5634.
Is there a simple way to do it?
Thanks.
Benson
Best Answer