Creating a text file to specific format
3 views (last 30 days)
Show older comments
Hi,
I have a matrix called data (3652500 x 3). But data matrix dont have the header (i.e. names).
I want to insert column headers as shown below and write the output to a text file inserting 4th column from another matrix called output (3652500 x 1). I need to insert the output matrix in the 4th column of data matrix with 3 spaces between 3rd columns and 4th column. (See the header and sample rows below)
DATE TMAX TMIN RAIN
3000001 -99.9 -99.9 0.6
3000002 -99.9 -99.9 0.5
How can I do it MATLAB.
Any help is appreciated.
Thanks.
0 Comments
Accepted Answer
Image Analyst
on 23 May 2014
Edited: Image Analyst
on 24 May 2014
With fprintf() you can make it look anyway you want. Have you tried that function?
output = 99*rand(10,4);
output(:,1) = round(output(:,1))
filename = 'deleteme.txt';
fid = fopen(filename, 'wt');
if fid ~= -1
fprintf(fid, 'DATE TMAX TMIN RAIN\n');
for row = 1 : size(output, 1)
fprintf(fid, '%d %.1f %.1f %.1f\n', output(row, :));
end
fclose(fid);
end
5 Comments
Image Analyst
on 25 May 2014
It's just like any format string that you're used to in most any other language that you've ever used. If you use %.1f, the field width varies according to the size of the number. If you put %6.1f, it will pad out to make it a fixed field width of 6 characters.
More Answers (0)
See Also
Categories
Find more on Characters and Strings 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!