Filter löschen
Filter löschen

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

2 Ansichten (letzte 30 Tage)
Xymbu
Xymbu am 11 Mai 2022
Kommentiert: Xymbu am 12 Mai 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.

Akzeptierte Antwort

Walter Roberson
Walter Roberson am 11 Mai 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 Kommentar
Xymbu
Xymbu am 12 Mai 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

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Characters and Strings finden Sie in Help Center und File Exchange

Tags

Produkte


Version

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by