Datetime, parsing problem

Question

mehra 2019-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/466064-datetime-parsing-problem

回答： mehra 2019-6-10

I am using Datetime function for a set of 104 excel data, but in some of the data I face with parsing error, although all the files have the same format and the excel cell that will be used in the datetime also is the same in all the data sets but datetime give error that it can not parse the

why this happens and how I can Solve it?

6 个评论
显示 4更早的评论隐藏 4更早的评论

mehra 2019-6-10

编辑：mehra 2019-6-10

在 MATLAB Online 中打开

I send some of the related lines, please let me know if somethıng else is needed

The Error I get (for almost Every other xlsx fıle ) is this one:

Error using datetime (line 593)

Unable to parse date/time string '09:55:46.663917949583 29.10.2018' using the format 'HH:mm:ss.SS dd.MM.yyyy'.

Error in data_processing_unsteady_2D_90sec_xz (line 79)

recdate=datetime(dummy2,'InputFormat','HH:mm:ss.SS dd.MM.yyyy');

I read my excel fıles by :

WL_data_list_xz1=dir('xz/*.xlsx');

The lines related to Error:

WL_datafilename=strcat('xz/',WL_data_list_xz1(n1).name);
[WL_time,dummy1,dummy2]=xlsread(WL_datafilename,1,'B8');
recdate=datetime(dummy2,'InputFormat','HH:mm:ss.SS dd.MM.yyyy'); 

Walter Roberson 2019-6-10

In datatime parsing, you cannot use SS to indicate that you want 12 digits of fractions of a second. You would need to use 12 S's to indicate 12 digits of fractions of a second. However, MATLAB only permits 9 S's, so your 09:55:46.663917949583 cannot be processed. MATLAB cannot store seconds that precise. You will need to process the times to reduce it to 9 digits.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2019-6-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/466064-datetime-parsing-problem#answer_378512

编辑：Walter Roberson 2019-6-10

在 MATLAB Online 中打开

dummy3 = regexprep(dummy2, '\.(\d{9})\d{3} ', '.$1 ');                      %remove last 3 digits
recdate = datetime(dummy3, 'InputFormat', 'HH:mm:ss.SSSSSSSSS dd.MM.yyyy'); 