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

7 visualizaciones (últimos 30 días)
Xymbu
Xymbu el 11 de Mayo de 2022
Comentada: Xymbu el 12 de Mayo de 2022
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.

Respuesta aceptada

Walter Roberson
Walter Roberson el 11 de Mayo de 2022
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 comentario
Xymbu
Xymbu el 12 de Mayo de 2022
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

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Characters and Strings en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by