Merge datetime with another cell for export
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
How do I combine two matrices of different types? I have a datetime matrix and one with pH values, and I would like to export them in one .csv file from matlab. When I try to merge them I get the error message "All inputs must be datetimes or date/time character vectors or date/time strings."
Is there a way to merge datetime with other cell matrices, and how is it done?
0 Kommentare
Akzeptierte Antwort
dpb
am 25 Jun. 2020
Bearbeitet: dpb
am 25 Jun. 2020
Sure...
>> c={datetime(now,'ConvertFrom','datenum'),pi}
c =
1×2 cell array
{[25-Jun-2020 08:22:52]} {[3.14]}
>> writecell(c,'C.csv')
>> type C.csv
25-Jun-2020 08:22:52,3.14159265358979
>>
writecell (as well as the various other builtin solutions) has the problem that the date string contains embedded blanks but is not quote-delimited. This means reading the file back in generally takes extra steps to keep the date and time from being broken apart into two variables.
To prevent this, use (what I think should be default instead of not) the 'QuoteStrings' parameter:
>> writecell(c,'C.csv','QuoteStrings',true)
>> type C.csv
"25-Jun-2020 08:22:52",3.14159265358979
>>
2 Kommentare
dpb
am 26 Jun. 2020
writecell outputs the cell array to reflect the internal storage order.
Above I created a 1x2 cell array so that is what was written.
Arrange your array as you want/need it to be output.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Type Identification finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!