Extracting characters out of a string array

Hi guys,

So I have a n rows by 1 column cell array with each cell containing a date string eg.20/02/201205:45:00PM. I would like to plot some data using this date and time string as the x-axis but notice that those entries are not in a format which matlab recognizes (no space between the date and the time).

So I would want to extract the date section and time section out of those entries and reconstruct my string array, putting a space in between so I can use the datenum function. What would be a good way to do this? Thanks in advance!!

Answer 1

[Andrei Bobrov]

c = {'20/02/201205:45:00PM';'21/02/201205:45:00AM'}

out = datenum(c,'dd/mm/yyyyHH:MM:SSPM')
out2 = datestr(out,'dd/mm/yyyy HH:MM:SS PM')

[Vincent]

Thz a lot andrei!! Never realised that I can specific the date string format in the datenum function!!