![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/367915/image.png)
How to replace two columns in a txt file?
2 views (last 30 days)
Show older comments
Benson Gou
on 25 Sep 2020
Commented: Sudhakar Shinde
on 30 Sep 2020
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
Accepted Answer
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');
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/367915/image.png)
4 Comments
More Answers (0)
See Also
Categories
Find more on Oceanography and Hydrology in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!