MATLAB: Import csv file with date and time in AM/PM format

csvdatetimeMATLAB

Hi everyone! I want to import some dates into Matlab but I do not seem to get the right datetime format. Normally I use Matlab's Import tool, and specify a format for my dates. My problem now is that I have the dates in AM/PM format which I am not familiar with. I have browsed through some examples without any luck. My question is: what is the proper format in order to import these dates in a datetime array?
MM/dd/yyyy HH:mm:ss ??
Some dates:
    (...)
    3/13/2017 11:20:00 PM
    3/13/2017 11:30:00 PM
    3/13/2017 11:40:00 PM
    3/13/2017 11:50:00 PM
    3/14/2017 12:00:00 AM
    3/14/2017 12:10:00 AM
    3/14/2017 12:20:00 AM
    (...)
I would sincerely appreciate any help. Thanks in advance!

Best Answer

Try this format
>> str =
3/13/2017 11:20:00 PM
>> cac = textscan( str, '%{MM/dd/yyyy hh:mm:ss a}D', 'Delimiter',',', 'Whitespace','' )
cac = 
    [03/13/2017 11:20:00 PM]
The problem seems to be to convince Matlab not to interpret the spaces as deliniters
Related Question