How to use fwrite with a format subject to change

1 次查看（过去 30 天）
012786534
012786534 2020-12-7
评论： 012786534 2020-12-7
Hi,
I have a basic question: I am doing multiple SQL queries and exporting the result to text files. I want to use fwrite to export the data but the number of variables and the data types are liable to change between queries. How could I build a script sufficiently flexible to handle that ?
var_a = {'T1','T1','T1','T1'}';
var_b = [2,2,2,2]';
var_c = {'A','A','A','A'}';
var_d = [8.12,7.67,5.90,3.81]';
t = table(var_a, var_b, var_c, var_d)
file_format = ['%s %d %s %f\n'];
y = table2cell(t).';
fid = fopen('test.txt', 'wt');
fprintf(fid, file_format, y{:});
fclose(fid);
Thank you,

请先登录，再回答此问题。

回答（1 个）

Steven Lord
Steven Lord 2020-12-7
Since you're already storing your data in a table array, why not just use writetable?
  1 个评论
012786534
012786534 2020-12-7
Because things like writetable and writecell are really slow and fwrite is much faster. This matters depending on the number of SQL queries and the size of the files

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 String Parsing 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by