How to replace two columns in a txt file?

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

Answer 1

[Sudhakar Shinde]

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');

[Benson Gou]

Hi, Sudhakar,

Thanks a lot for your great help.

I want to write the new C into another txt file "textnew.txt".

By the way, I want to replace the entire 2 columns, not just the first element. For example, I want to change the 9th and 10th columns with the following values:

1.0269 -11.382 --> 0.9987 -10.5634

1.0269 -16.365 --> 1.0320 0.9987

1.0162 -13.797 --> 0.9982 -17.2319

1.0179 -13.586 --> 1.2510 -19.8923

The length of these 2 columns are 4500.

Thanks a lot.

Benson

[Sudhakar Shinde]

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]

Hi, Sudhakar,

Thanks a lot for your great help. I solved my problem.

Best regards,

Benson

[Sudhakar Shinde]

Welcome