Import csv file with date and time in AM/PM format
6 views (last 30 days)
Show older comments
Adriel Perez Tellez
on 6 Jun 2017
Commented: Laraib Imtiaz
on 19 Jun 2018
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!
1 Comment
Stephen23
on 6 Jun 2017
Is it possible to change the date format to something more sensible (and universal), e.g.:
Accepted Answer
per isakson
on 6 Jun 2017
Edited: per isakson
on 6 Jun 2017
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
2 Comments
More Answers (0)
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!