Problems with te output of writetable function

Question

Wesso 2019-3-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/447999-problems-with-te-output-of-writetable-function

评论： Walter Roberson 2019-3-4

采纳的回答： Guillaume

FinalMatlab.csv

在 MATLAB Online 中打开

writetable(E,'FinalMatlab.csv')

I ended up with the attached output. in row 33 the columns were not written completely and instead were written on the next row (before ID 34). Also, it would be great if NaT and Nan could be replaced by empty cells.

Any help would be greatly appreciated

3 个评论
显示 1更早的评论隐藏 1更早的评论

Wesso 2019-3-4

编辑：Wesso 2019-3-4

matlab.mat

thanks Walter. Attached the first 35 rows in the mat file and I kept in the mat file the names of real variables used in case they were the source of problem

Wesso 2019-3-4

sorry the initial file is too big to upload it . so I took the first 35 rows

请先登录，再进行评论。

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

Answer 1

Guillaume 2019-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/447999-problems-with-te-output-of-writetable-function#answer_363774

在 MATLAB Online 中打开

Walter was correct, some of your text fields contain newlines. So, of course, when the newlines are written it messes up the file for some csv readers. Note that any entry with newlines are enclosed in double quotes, so if the parser works detects quoted strings properly it should read the file correctly.

Probably best, is to get rid of these newlines characters. An easy way:

yourtable(:, vartype('cellsttr')) = varfun(@(v) regexprep(v, '[\n\r]', ''), yourtable(:, vartype('cellstr')));
writetable(yourtable, 'something.csv');

You might similarly want to get rid of commas within your text (or replace them with something else), if it's going to confuse your reader.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Guillaume 2019-3-4

Oops, typo, should be 'cellstr' not 'cellsttr'. It's spelled correctly in the 2nd occurence.

Walter Roberson 2019-3-4

I would probably replace with a space rather than with emptiness so that adjacent words do not run together. Or I would replace with '\\n' to put literal character pair \n as the replacement, expecting you to transform them back upon reading.

请先登录，再进行评论。