How to convert a cell vector with numbers and non-numbers into a comma-seprated (.csv) format?

Hi,

I have the cell array:

Matrix(1,1) = {'ABCD'}
Matrix(1,2) = {'*'}
Matrix(2,1) = {'251'}
Matrix(2,2) = {'0'}
Matrix(3,1) = {'*'}
Matrix(3,2) = {'01/12/2001'}

I need to export a csv (I guess using csvwrite function) with this format:

ABCD,*
251,0
*,01/12/2001

Someone can help me? Many thanks!

Answer 1

[Julia Antoniou]

Hi Adriano,

You could accomplish this with the following commands:

T = cell2table(Matrix);
writetable(T,'filename.csv','WriteVariableNames',false);

See this documentation page for more information about the "writetable" function.

[Adriano]

Many thanks...It works!