Datetime, parsing problem

2019 6 7
3 个回答
回答已采纳
更新时间：2019 6 10
6 次查看（30 天）

0 个投票

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更早的评论

Walter Roberson
Walter Roberson 2019-6-7
How are you reading the file?
Which release are you using? And are you using MS Windows on a system with Excel installed?
Would it be possible for you to attach one of the failing files?
dpb
dpb 2019-6-7
Walter's correct that would likely have to have a failing file to be able to diagnose the issue...
dpb
dpb 2019-6-7
[Answer moved to comment--dpb]
I read my files with xlsread and they seem to be ok because I used these commands for other things, The Error that it gives meis that it cannot 'Parse' the data not reading the file
it seems that the format of the cell with date is different, but i checked it and its all the same!!!
dpb
dpb 2019-6-7
Well, there's nothing we can do for you unless and until you attach one of the failing files for somebody else to test with...
mehra
mehra 2019-6-10
编辑：mehra 2019-6-10
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
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.

请先登录，再进行评论。

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

 采纳的回答

Walter Roberson
Walter Roberson 2019-6-10
编辑：Walter Roberson 2019-6-10

0 个投票

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

更多回答（2 个）

mehra
mehra 2019-6-10

0 个投票

Thank you very much, but here some of my fıles can be processed however in all of them there are 12 digits for seconds

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by