Problem using "datetime"

3 Ansichten (letzte 30 Tage)
Andy Wileman
Andy Wileman am 16 Mär. 2021
Kommentiert: Andy Wileman am 17 Mär. 2021
Hi,
I'm trying to import data from a structure and save it as a file with the data in the filename. See my previous problems. I have got as far as the code below, but have run into the following problem:
Error in extractor (line 14)
T = table(N, 'VariableNames', {'Dates'})
Caused by:
You might have intended to create a one-row table with the
character vector '12/24/2008 9:59:47 AM.786743640' as one
of its variables. To store text data in a table, use a
string array or a cell array of character vectors rather
than character arrays. Alternatively, create a cell array
with one row, and convert that to a table using
CELL2TABLE.
My code is a follows, it shows the current date format stored in dateName and the filename I would like to store the data in timeDom under.
load('Device2_13032021.mat');
L = length(measurement.transient);
for i = 1:L
dateName = {measurement.transient(i).date};
timeDom = {measurement.transient(i).timeDomain};
%Current file format{'12/24/2008 9:59:47 AM.786743640'}
%Fileformat to convert to = data-20130325T004512Z.mat
date=cell2mat(dateName);
data=cell2mat(timeDom);
N = date
T = table(N, 'VariableNames', {'Dates'})
t = datetime(T.Dates,'ConvertFrom', 'dd/mm/yyyy''T''HHmmss''Z');
% TODO: Save files
save(data, '-append', '-struct', 't');
%
end
I would be grateful if anyone could shed some light on where things have gone wrong.
Kind regards,
Andy
  1 Kommentar
Adam Danz
Adam Danz am 16 Mär. 2021
If you format your code, it would be much easier to read.
See the "text/code" toggle button: https://www.mathworks.com/matlabcentral/help/rtc

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Adam Danz
Adam Danz am 16 Mär. 2021
T = table(string(N), 'VariableNames', {'Dates'})

Weitere Antworten (0)

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Tags

Produkte


Version

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by