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

7 views (last 30 days)
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.

Accepted Answer

Walter Roberson
Walter Roberson on 11 May 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 Comment
Xymbu
Xymbu on 12 May 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

Sign in to comment.

More Answers (0)

Categories

Find more on Characters and Strings in Help Center and File Exchange

Tags

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!