trouble using datetime format in textscan
18 views (last 30 days)
Show older comments
this datetime format works
datetime('2021-05-01 06:10:00','inputFormat','yyyy-MM-dd HH:mm:ss')
so why won't
>> textscan('2021-05-01 06:10:00','%{yyyy-MM-dd HH:mm:ss}D')
Error using textscan
Unable to read the DATETIME data with the format 'yyyy-MM-dd HH:mm:ss'. If the data is not a time, use %q to get text data.
Thanks.
0 Comments
Accepted Answer
Cris LaPierre
on 20 Jul 2021
The problem is because textscan uses white space as the default delimiter. Specify your delimiter or remove the space between date and time.
d1 = textscan('2021-05-01 06:10:00','%{yyyy-MM-dd hh:mm:ss}D','Delimiter','\t')
d2 = textscan('2021-05-0106:10:00','%{yyyy-MM-ddhh:mm:ss}D');
d2{1}.Format = 'yyyy-MM-dd hh:mm:ss'
More Answers (1)
Simon Chan
on 20 Jul 2021
Detail explanation here: How do I use 'textscan' to correctly read a formatted date?
0 Comments
See Also
Categories
Find more on Text Data Preparation in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!