How to save a text file with headers?
44 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
dpb
on 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 Comments
dpb
on 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.
More Answers (0)
See Also
Categories
Find more on Structures 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!