how can I use dlmwrite for string and matrix in single line ?

I want to write a txt file and when I use dlmwrite to write string and matrix together , output file include string in line1 and matrix in line 2 , how can I write them in single line ?

values='values.txt'       %output file name

str='set '                %string

col=[1.2,2.2,3.2,4.2,5.2]           %matrix 

dlmwrite(values,str,'delimiter', '')

dlmwrite(values, col, '-append','delimiter', ' ')

output file is :

set 

1.2 2.2 3.2 4.2 5.2

while I want to write :

set 1.2 2.2 3.2 4.2 5.2

Thanks , Farhad

Answer 1

[Walter Roberson]

Same answer as at https://www.mathworks.com/matlabcentral/answers/364174-how-can-i-write-data-to-a-text-file-using-the-symbol-in-the-end#answer_288598

[Farhad Mirsaeidghazi]

thank you , It works .

[Walter Roberson]

Actually the intended lesson of that is "Don't use dlmwrite() for this purpose."

[Farhad Mirsaeidghazi]

what's the appropriate command for that?

[Walter Roberson]

xlswrite() or writetable() or fopen/fprintf/fclose

Answer 2

[Jang Bahadur Singh]

str={'set '};               
col=[1.2,2.2,3.2,4.2,5.2];          
A1 =[a1 col]; 
er1=table(A1);
writetable(er1,'xx1.txt','Delimiter','\t','WriteRowName',true)

[Georgios Kokogiannakis]

Hi,

I have the same question as above. writetable is extremely slow for a relatively big dataset.My task is to replace my current code which uses writetable with dlmwrite but I struggle as above (it will save me about 6 hours every time I run the code). I use fprintf for my headers of my csv file fprintf does not put the comma delimiter. Help please.

[Walter Roberson]

data = round( 10 * rand(100,3), 1 );  %for example

headers = {'name1', 'another name', 'var3'};  %for example
ncol = size(data, 2);

fid = fopen('xx1.txt', 'wt');
fprintf(fid, '%s,', headers{1:end-1});
fprintf(fid, '%s\n', headers{end});

fmt = [repmat('%f,', 1, ncol-1), '%f\n'];

fprintf(fid, fmt, data.' );   %transpose is important

fclose(fid);