i want to use the fonction (csvwrite) to write S into a fiche csv,but i get a result like this,anyone can help me? thank you

S =

    '4400000570000000008'    '4400000570000000013'
    '4400000570000000001'    '4400000570000000014'
    '4400000570000000003'    '4400000570000000006'
    '4400000570000000000'    '4400000570000000010'
    '4400000570000000002'    '4400000570000000006'
    '4400000570000000002'    '4400000570000000007'
    '4400000570000000002'    '4400000570000000008'
    '4400000570000000007'    '4400000570000000008'
    '4400000570000000004'    '4400000570000000007'
    '4400000570000000001'    '4400000570000000012'
    '4400000570000000001'    '4400000570000000013'
    '4400000570000000012'    '4400000570000000013'

csvwrite('cilpc.csv',S,0,0);

4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,8,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,3 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,1,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,4 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,3,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,6 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,0,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,0 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,2,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,6 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,2,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,7 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,2,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,8 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,7,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,8 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,4,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,7 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,1,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,2 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,0,1,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,3 4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,2,4,4,0,0,0,0,0,5,7,0,0,0,0,0,0,0,0,1,3

Answer 1

[Guillaume]

You can't use csvwrite for this. It's fairly simple with low level functions anyway:

fid = fopen('cilpc.csv', 'wt');
for row = 1: size(S, 1)
  fprintf(fid, '%s\n', strjoin(S(row, :), ','));
end
fclose(fid);

[pengcheng]

thank you ,i think it can work, but my matlab lacks the fonction strjoin,do you have a substitution?

[Guillaume]

Here is a basic implementation of strjoin, without any error checking:

function [string] = strjoin(stringcells, separator)    
    if numel(stringcells) == 0
        string = '';
    else
        string = stringcells{1};
        for elem = 2 : numel(stringcells)
            string = [string separator stringcells{elem}];
        end
    end  
end

[Guillaume]

Alternatively, you can replace the fprintf line in my answer with:

for col = 1 : size(S, 2)-1
  fprintf(fid, '%s,', S(row, col));
end
fprintf(fid, '%s\n', S(row, end));

[pengcheng]

it write like this:Error using fprintf Function is not defined for 'cell' inputs.

[Guillaume]

Yes, sorry, replace any instance of

S(x,y)

with

S{x,y}

[pengcheng]

 fid = fopen('cimal.csv', 'wt');
for row = 1: size(S, 1)
    fprintf(fid, '%s,', S{row});
    fprintf(fid, '%s\n', S{row, end});
end
fclose(fid);
It works ,thank you very much

[Guillaume]

The code you've posted works as long as S is only two columns. If that is the case, you could just replace the two fprintf with one:

fprintf(fid, '%s,%s\n', S{row, 1}, s{row, 2});

For reference, a code that will work regardless of the number of columns in S:

fid = fopen('cilpc.csv', 'wt');
for row = 1:size(S, 1)
   for col = 1:size(S, 2)-1;
      fprintf(fid, '%s,', S{row, col});
   end
   fprintf(fid, '%s\n', S{row, end});
end
fclose(fid);