Datetime, parsing problem

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?

[Walter Roberson]

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]

Walter's correct that would likely have to have a failing file to be able to diagnose the issue...

[dpb]

[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]

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]

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]

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]

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

Answer 2

[mehra]

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

Answer 3

[mehra]

Thank you very much