MATLAB: Datetime, parsing problem

Question

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?

Answer 1

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