Manipulate numbers in existing txt file
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Stefan
am 18 Dez. 2017
Kommentiert: Stefan
am 19 Dez. 2017
Hi,
I want to manipulate numbers in a txt file which was created by catia. The txt file looks like this:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/167825/image.png)
Catia puts a space between every string and float. For example I want to change 'l_overall (mm)' to 5000.
Thank you for your help!
1 Kommentar
Walter Roberson
am 18 Dez. 2017
I notice that there is a space between l_overall and (mm) and a space between w_overall and (mm) but no space between h_overall and (mm) . Is the actual file consistent about the space there or not?
Can we assume that the variables are always in exactly the same order and that we can assume that l_overall will be the first entry on the line (for example) ? Or is it necessary to match the strings to determine which column to make the change to ?
Is it possible that the fields are really tab delimited rather than space delimited ?
Akzeptierte Antwort
Walter Roberson
am 19 Dez. 2017
fid = fopen('Table1.txt', 'rt');
colnames = fgetl(fid);
colvals = fscanf(fid, '%f', [1 inf]);
fclose(fid)
colvals(1) = 5000;
fid = fopen('newTable1.txt', 'wt');
fprintf(fid, '%s\n', colnames);
fprintf(fid, '%g\t', colvals(1:end-1));
fprintf(fid, '%g\n', colvals(end));
fclose(fid)
Weitere Antworten (1)
YT
am 18 Dez. 2017
I don't know if I understand the question correctly, but if you want to change 'l_overall (mm)' to '5000' in your text file, you can do something like this (I assumed that your text file looks something like the test.txt I attached)
clear all;
fileID = fopen('test.txt');
C = textscan(fileID,'%s','delimiter','\n');
fclose(fileID);
C{:} = strrep(C{:},'l_overall (mm)','5000'); %replacing 'l_overall (mm)' by '5000'
writetable(cell2table(C{:}),'updated_data.txt','WriteVariableNames',0) %writing the new data
3 Kommentare
Walter Roberson
am 19 Dez. 2017
You would get that textscan error if you provided the wrong filename to fopen()
Walter Roberson
am 19 Dez. 2017
"There is a space between every column header, unit and variable"
The delimiter between columns is tab, just as I had guessed.
Siehe auch
Kategorien
Mehr zu String Parsing finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!