fprintf for 6 array in double type and 2 date vectors

Hi All,

I want to use fprintf for 6 double arrays and 2 date vectors. The dates will be at the first and second column and double arrays will come after. All of the arrays are 48x1 so I want them to get placed in 48 rows and 8 columns as a shape of 48x8 table. And also I want their headers on top. Headers are char as well. I wrote the code below but it gives very messy table.

filename = 'Results.csv';
fid = fopen(filename, 'wt');

if fid ~= -1
    fprintf(filename,'%6s', column_headers);

    for row = 1 : length(M)
        fprintf(fid, '%s %12.4f %12.4f %d %d %d %d %d %d \n', char(date1(row,:)),char(date2(row,:)), dataRes(row), M(row), M2(row), M3(row),M4(row),MWDif(row));
    end
    fclose(fid);
end

Thanks in advance.

[dpb]

printf(filename,'%6s', column_headers);
for row = 1 : length(M)
  fprintf(fid, '%s %12.4f %12.4f %d %d %d %d %d %d \n',
  

You created header row with only 6 columns widths and then wrote data of:

length(date format) 12 12 five_variable_width

Use counted widths for every column, including what is needed for spacing. There are examples with fprintf of similar idea.

BTW a convenient ML idiom in creating format strings for repeated variables is

  fmt=['%14s' repmat('%12.4f', 1,2) repmat('%6d',1,6) '\n'];

or similar

Answer 1

[Stephen23]

Your format string does not match your data. In your question you describe and show 2 char variables and 6 numeric variables, but in your format string you have:

 '%s %12.4f %12.4f %d %d %d %d %d %d \n'
% 1                                    -> one char format.
%    1      2      3  4  5  6  7  8    -> eight numeric formats.

Your code with some changes:

fnm = 'Results.csv';
[fid,msg] = fopen(fnm,'wt');
assert(fid>=3,msg) % better than |if|
fmt = '%s %s %s %s %s %s %s %s\n'; % 8 char, for header.
fprintf(fid,fmt,column_headers); % Does this work? Maybe you need to change this.
fmt = '%s %s %d %d %d %d %d %d\n'; % 2 char, 6 numeric.
for k = 1:numel(M)
    fprintf(fid, fmt, char(date1(k,:)),char(date2(k,:)),dataRes(k),M(k),M2(k),M3(k),M4(k),MWDif(k));
end
fclose(fid);

[Omer Yasin Birey]

Thank you Stephen that worked! You were also right about the line column_headers I changed it.