how can I append this format using dlmwrite ?
14 次查看(过去 30 天)
显示 更早的评论
I wanna the result in the text file to be
1 2 4 A
5 6 7 B
8 9 0 C
I used this formula but the result is not what I want
A=[1 2 4;5 6 7;8 9 0] B=[A;B;C]
dlmwrite('DECALLFEATURES.csv',A,'-append', 'newline', 'pc');
dlmwrite('DECALLFEATURES.csv',B,'delimiter','','-append','newline', 'pc');
回答(1 个)
Walter Roberson
2018-2-9
dlmwrite() cannot be used to output a mix of text and numeric on the same call.
dlmwrite() does not like to output text at all. You can trick it into handling text by setting the Delimiter property to empty, and set 'precision' to '%s', and pass in a character array with one row per line in which each row is the same length and contains all necessary characters including commas where you want to put the cell boundaries. dlmwrite() is not able to handle cell arrays.
dlmwrite() never appends to the end of an existing line. The -append flag causes it to add new data after all existing lines. The 'coffset' specification causes it to overwrite the file (unless -append was used) putting that many empty columns before the new data it writes.
I recommend you give up on using dlmwrite for this purpose.
You could switch to fopen/fprintf
A=[1 2 4;5 6 7;8 9 0]; B={'A';'B';'C'};
fid = fopen('DECALLFEATURES.csv', 'wt');
data_cell = [num2cell(A), B] .'; %transpose is important
fmt = [repmat('%d ', 1, size(A,2)), '%s\n'];
fprintf(fid, fmt, data_cell{:});
fclose(fid);
I do have to wonder why you are using a .csv file when you only have a single cell per line? csv does not interpret blanks as indicating the end of cells, so you are not creating a csv with 3 x 4 data, you are creating a csv with 3 x 1 data. csv expect commas to delimit cells.
10 个评论
Walter Roberson
2018-2-12
You assigned a cell array to the variable name table but the code I gave needs to use the function named table.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!