Problem using "datetime"

4 views (last 30 days)
Andy Wileman
Andy Wileman on 16 Mar 2021
Commented: Andy Wileman on 17 Mar 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 Comment
Adam Danz
Adam Danz on 16 Mar 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

Sign in to comment.

Accepted Answer

Adam Danz
Adam Danz on 16 Mar 2021
T = table(string(N), 'VariableNames', {'Dates'})

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!