Write a cell arrary of strings into a signle cell on a csv.

Question

Xymbu 2022-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1717120-write-a-cell-arrary-of-strings-into-a-signle-cell-on-a-csv

评论： Xymbu 2022-5-12

I have a 1x4 cell array with strings and I want to write them all into a single cell on a csv file like when you hit alt+enter to make a newline in a cell when using a csv.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2022-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1717120-write-a-cell-arrary-of-strings-into-a-signle-cell-on-a-csv#answer_962210

It looks like what excel needs for this case is for the file to start with the UTF-8 Byte Order Mark (BOM), and that the embedded line break is in a field with double quotes around the field, and the line break must be just the newline character, and the end of record must be carriage return followed by newline.

https://stackoverflow.com/questions/1241220/generating-csv-file-for-excel-how-to-have-a-newline-inside-a-value

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

Xymbu 2022-5-12

What I ended up doing instead was just turn it into a single string with a string that signifies the line break then I could turn them back into seperate cells when i read it back into matlab seperating with that string

请先登录，再进行评论。