Datetime, parsing problem
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
mehra
el 7 de Jun. de 2019
Respondida: mehra
el 10 de Jun. de 2019
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 comentarios
Walter Roberson
el 10 de Jun. de 2019
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.
Respuesta aceptada
Walter Roberson
el 10 de Jun. de 2019
Editada: Walter Roberson
el 10 de Jun. de 2019
dummy3 = regexprep(dummy2, '\.(\d{9})\d{3} ', '.$1 '); %remove last 3 digits
recdate = datetime(dummy3, 'InputFormat', 'HH:mm:ss.SSSSSSSSS dd.MM.yyyy');
0 comentarios
Más respuestas (2)
Ver también
Categorías
Más información sobre Dates and Time en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!