MATLAB Answers

How to replace two columns in a txt file?

2 views (last 30 days)
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

  0 Comments

Sign in to comment.

Accepted Answer

Sudhakar Shinde
Sudhakar Shinde on 28 Sep 2020
This could help you:
fid = fopen('test.txt');
C = textscan(fopen('test.txt'),'%s','delimiter','\n');
C=strrep(C{1}, '1.0269','0.9987');
C=strrep(C, '-11.382','-10.5634');
fid = fopen('test.txt','w');

  4 Comments

Show 1 older comment
Sudhakar Shinde
Sudhakar Shinde on 29 Sep 2020
Hello Benson, Can you share your text file so that i can simply change its 9th and 10th column with the above data and write in another text file 'textnew.txt'.
Benson Gou
Benson Gou on 29 Sep 2020
Hi, Sudhakar,
Thanks a lot for your great help. I solved my problem.
Best regards,
Benson

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!