Can't get string to datetime conversion to work

Question

Nathan Heller 2021-6-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/854180-can-t-get-string-to-datetime-conversion-to-work

评论： Nathan Heller 2021-6-12

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

There seems to be some sort of inconsistency in the converting to datetime code I missed.

q=datetime('2017-05-17 19:36:00', 'InputFormat','yyyy-MM-dd HH:mm:ss')

this works just fine. However, when I am reading the input string '2017-05-17T19:36:00' from an array, stripping the T, and putting it in exactly the same, it fails to work. example:

%data{1}(n) has the string '2019-05-17T19:36:00'
b = strrep(data{1}(n),'T',' ');
disp(b);
%displaying displays 2017-05-17 19:36:00, just like the earlier statement
timestamp = datetime(b,'InputFormat',format);

When I do this, the error message:

Unable to convert '﻿2017-05-17 19:36:00' to datetime using the format 'yyyy-MM-dd HH:mm:ss'.

is displayed. Am i missing something? are these not exactly the same? Thanks for your help.

2 个评论
显示无隐藏无

Walter Roberson 2021-6-11

could you attach data{1} as a mat file so we can check for odd characters?

Nathan Heller 2021-6-11

data.mat

here you go

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2021-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/854180-can-t-get-string-to-datetime-conversion-to-work#answer_722920

The very first entry in your data{1} has a leading U+FEFF character, which is a unicode Byte Order Mark character, but is to be interpreted as a Zero-Width Non-Breaking Space if it occurs anywhere other than the first position

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2021-6-12

It probably only occurs once, but to be sure, use another strrep to replace char(65279) with empty

Nathan Heller 2021-6-12

Thanks for all your help!

请先登录，再进行评论。

Answer 2

J. Alex Lee 2021-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/854180-can-t-get-string-to-datetime-conversion-to-work#answer_722895

在 MATLAB Online 中打开

str = '2019-05-17T19:36:00';
fmt = 'yyyy-MM-dd HH:mm:ss';
b = strrep(str,'T',' ');
disp(b);
2019-05-17 19:36:00
timestamp = datetime(b,'InputFormat',fmt)
timestamp = datetime
   17-May-2019 19:36:00