When I export results to a text file or csv etc, it is written in only one line, how do I make that it appear in columns?

Hello!

sigma, x, res... are all 10 dimensional vectors that I want them to appear in different columns. When I run the code everything in the txt file is in one line, separated with comas.

T=table(sigma,x,res,dist,k,p);

csvFile = 'table_data.csv';
writetable(T, csvFile);

[Dyuman Joshi]

Are they 10 dimensional or a column vector with 10 elements?

[Voss]

Or a row vector with 10 elements?

[Samuel Tárraga Habas]

Yes, they are row vectors with 10 elements, like sigma={0,1,2,3,...}

[Dyuman Joshi]

Just to clarify -

Like this

(0:9)

ans = 1×10

0 1 2 3 4 5 6 7 8 9

or

{0:9}

ans = 1×1 cell array
    {[0 1 2 3 4 5 6 7 8 9]}

or

num2cell(0:9)

ans = 1×10 cell array
    {[0]}    {[1]}    {[2]}    {[3]}    {[4]}    {[5]}    {[6]}    {[7]}    {[8]}    {[9]}

[Samuel Tárraga Habas]

The first one! Thank you for the clarification.

[Stephen23]

"sigma, x, res... are all 10 dimensional vectors..."

Note for the future: they have only two dimensions. And ten elements each.

ndims(0:9)

ans = 2

numel(0:9)

ans = 10

Answer 1

[Voss]

T=table(sigma(:),x(:),res(:),dist(:),k(:),p(:), ...
    'VariableNames',{'sigma','x','res','dist','k','p'});

csvFile = 'table_data.csv';
writetable(T, csvFile);

[Samuel Tárraga Habas]

Doing that I have the same problem of having the elements in only a row

[Voss]

Strange. It seems to work here:

sigma = 0:9;
x = 1:10;

% original method:
T=table(sigma,x)

T = 1×2 table
       sigma            x     
    ___________    ___________

    1×10 double    1×10 double

csvFile = 'table_data_original.csv';
writetable(T, csvFile);
type(csvFile)

sigma_1,sigma_2,sigma_3,sigma_4,sigma_5,sigma_6,sigma_7,sigma_8,sigma_9,sigma_10,x_1,x_2,x_3,x_4,x_5,x_6,x_7,x_8,x_9,x_10
0,1,2,3,4,5,6,7,8,9,1,2,3,4,5,6,7,8,9,10

% proposed solution:
T=table(sigma(:),x(:), ...
    'VariableNames',{'sigma','x'})

T = 10×2 table
    sigma    x 
    _____    __

      0       1
      1       2
      2       3
      3       4
      4       5
      5       6
      6       7
      7       8
      8       9
      9      10

csvFile = 'table_data.csv';
writetable(T, csvFile);
type(csvFile)

sigma,x
0,1
1,2
2,3
3,4
4,5
5,6
6,7
7,8
8,9
9,10

[Samuel Tárraga Habas]

Yessss!!! It worked, I thought I had to remove the 3 dots. Thank you very much.

[Voss]

You're welcome!