MATLAB Answers

How to save a text file with headers?

조회 수: 6(최근 30일)
Dorsa Mir Norouzi
Dorsa Mir Norouzi 24 Aug 2020
댓글: dpb 25 Aug 2020
For context, the full code reads data from a text file, calibrates and converts the data to degrees, and then saves the new data in 4 columns with 108766 rows each. This is what I am currently using to save the new text file:
function calibratedData = applyCal(fname,Ey,components,rawData,Calib)
% applies calibration (gain and shift) to raw data; function returns
% calibrated data ONLY for 'components'!
calibratedData = [];
for i = find(components)
calibratedData(:,Ey(i).datacolumn) = ( rawData(:,Ey(i).datacolumn) - Calib(1,Ey(i).datacolumn) ) * Calib(2,Ey(i).datacolumn);
end
%save as textfile:
s = strtok(fname,'.');
SaveName = [s, datestr(now, ' yyyymmddTHHMMSS'),' calibrated.txt'];
save (SaveName, 'calibratedData', '-ASCII');
end
This works - but I need there to be a header at the top of each column. The headers need to be "LE Horizontal" "LE Vertical" "RE Horizontal" and "RE Vertical". Any help would be appreciated! Thank you!

  댓글 수: 3

Adam Danz
Adam Danz 24 Aug 2020
Convert your array to a table using array2table where you can also specify the header names. Then use writetable to write the table to a text file.
Dorsa Mir Norouzi
Dorsa Mir Norouzi 24 Aug 2020
I tried to do this, but I get an error saying that my array "calibratedData" is undefined. But it is defined... so I'm not sure what's going on.
Adam Danz
Adam Danz 24 Aug 2020
That's not a problem with any Matlab functions. That indicates that you're building the table in the wrong place, specifically, before the vcalibratedData variable is defined or, perhaps, in a different workspace.

댓글을 달려면 로그인하십시오.

채택된 답변

dpb
dpb 24 Aug 2020
function calibratedData = applyCal(fname,Ey,components,rawData,Calib)
% applies calibration (gain and shift) to raw data; function returns
% calibrated data ONLY for 'components'!
calibratedData = [];
for i = find(components)
calibratedData(:,Ey(i).datacolumn) = ( rawData(:,Ey(i).datacolumn) - Calib(1,Ey(i).datacolumn) ) * Calib(2,Ey(i).datacolumn);
end
%save as textfile:
s = strtok(fname,'.');
SaveName = [s, datestr(now, ' yyyymmddTHHMMSS'),' calibrated.txt'];
names={'"LE Horizontal"','"LE Vertical"','"RE Horizontal"','"RE Vertical"'};
writecell(names,SaveName,'delimiter','space');
save(SaveName, 'calibratedData', '-ASCII' '-append');
end
saves having to create the table just for the purpose of writing a header line. Second time come up in last couple of days...see

  댓글 수: 12

표시 이전 댓글 수: 9
Dorsa Mir Norouzi
Dorsa Mir Norouzi 25 Aug 2020
Actually, ^^ you can disregard that part. I increased the field width and it worked. The issue now is that the last two columns are merging together and the headers aren't aligned with the data.. I've attached a photo to show. This is the code now:
function calibratedData = applyCal(fname,Ey,components,rawData,Calib)
% applies calibration (gain and shift) to raw data; function returns
% calibrated data ONLY for 'components'!
calibratedData = [];
for i = find(components)
calibratedData(:,Ey(i).datacolumn) = ( rawData(:,Ey(i).datacolumn) - Calib(1,Ey(i).datacolumn) ) * Calib(2,Ey(i).datacolumn);
end
s = strtok(fname, '.');
SaveName = [s, datestr(now, ' yyyymmddTHHMMSS'),' calibrated.txt'];
names={'Blank','LE Horizontal','LE Vertical','RE Horizontal','RE Vertical'};
fmt1=[repmat('%15s ',1,numel(names)-1) '%s\n'];
fmt2=[repmat('%15e ',1,numel(names)-1) '%f\n'];
fid=fopen(SaveName,'w'); % create the file for write
fprintf(fid,fmt1,names{:}); % note the {} to dereference cellstr to char strings
fprintf(fid,fmt2,calibratedData.'); % note the .' to write in row-major order to file
fid=fclose(fid); % close the file w/ header
save(SaveName, 'calibratedData', '-ASCII', '-append');
end
This also ends up happening in the file: I should only have 108766 samples in this file, but there are more samples when I use this new code? And the new samples have extra digits which throws off the entire alignmend. Sorry for so many edits, I'm just trying to figure out what's going on and update this as I go.
Dorsa Mir Norouzi
Dorsa Mir Norouzi 25 Aug 2020
Okay, last update. So looks like the solution was much more simple than I thought... Here is the final code that ended up working for me. Thank you again for all your help, it was very beneficial!!
function calibratedData = applyCal(fname,Ey,components,rawData,Calib)
% applies calibration (gain and shift) to raw data; function returns
% calibrated data ONLY for 'components'!
calibratedData = [];
for i = find(components)
calibratedData(:,Ey(i).datacolumn) = ( rawData(:,Ey(i).datacolumn) - Calib(1,Ey(i).datacolumn) ) * Calib(2,Ey(i).datacolumn);
end
s = strtok(fname,'.');
SaveName = [s, datestr(now, ' yyyymmddTHHMMSS'),' calibrated.txt'];
save (SaveName, 'calibratedData', '-ASCII');
fid=fopen(SaveName,'w'); % create the file for write
fprintf(fid,'%15s %15s %15s %15s %15s\n', 'blank', 'LEH', 'LEV', 'REH', 'REV');
fid=fclose(fid); % close the file w/ header
save(SaveName, 'calibratedData', '-ASCII', '-append');
end
dpb
dpb 25 Aug 2020
names={'Blank','LE Horizontal','LE Vertical','RE Horizontal','RE Vertical'};
fmt1=[repmat('%15s ',1,numel(names)-1) '%s\n'];
fmt2=[repmat('%15e ',1,numel(names)-1) '%f\n'];
The format width parameter is missing on the last element for each -- there are N-1 w/ trailing blank and one w/o. If you use the width parameter, then you can change that...
fmt1=[repmat('%15s ',1,numel(names)) '\n'];
fmt2=[repmat('%15e ',1,numel(names)) '\n'];
In the remainder
...
fprintf(fid,fmt2,calibratedData.'); % note the .' to write in row-major order to file
fid=fclose(fid); % close the file w/ header
save(SaveName, 'calibratedData', '-ASCII', '-append');
you write the data array twice -- once w/ fprintf with the width specified with fmt2 format string and then again you append the data to the file with save with the default format it uses. Use one but only one; I would recommend fprintf over the save .... -append route.

댓글을 달려면 로그인하십시오.

추가 답변(0개)

태그

제품


릴리스

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by