datenum with multiple formats

1 次查看（过去 30 天）
Connor Brackley
Connor Brackley 2019-2-4
编辑： Connor Brackley 2019-2-13
Hi All,
I am trying to convert a string array into a date serial.
When i use xlsread to import an excel document, it imports the following string array.
'01/01/2015 9:00:00 PM'
'01/01/2015 10:00:00 PM'
'01/01/2015 11:00:00 PM'
'02/01/2015'
'02/01/2015 1:00:00 AM'
'02/01/2015 2:00:00 AM'
'02/01/2015 3:00:00 AM'
in general it is in the format:
'mm/dd/yyyy HH:MM:SS PM'
but the imported 12am timestamps are formatted without the time. So when I provided datenum with that format:
datenum(txt,'mm/dd/yyyy HH:MM:SS PM')
it has an error when it it gets to the items without the time string.
Then if I dont provide the format, it assumes it is in the form 'dd/mm ...'
How can I efficently convert this array into date serials?
Thanks!

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

采纳的回答

Connor Brackley
Connor Brackley 2019-2-13
编辑：Connor Brackley 2019-2-13
"Use readtable() to read the file."
Thanks madhan ravi, using read table instead did the trick

更多回答（0 个）

类别

在 Help Center 和 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