MATLAB: Character to date and time

characterdate and time

I have a series of date & time data as below
      '2012-03-01T00:01:00.000Z'
      '2012-03-01T00:30:59.999Z'
      '2012-03-01T01:00:59.999Z'
      '2012-03-01T01:31:00.000Z'
      '2012-03-01T02:00:59.999Z'
      '2012-03-01T02:29:59.999Z'
      '2012-03-01T03:00:00.000Z'
I would like to remove 'T' and 'Z' and re-write the above into another date/time series of a form (please note a space between date and time):
01/03/2012 00:01:00.000
01/03/2012 00:30:59.999
01/03/2012 01:00:59.999
01/03/2012 01:31:00.000
01/03/2012 02:00:59.000
01/03/2012 02:29:59.999
01/03/2012 03:00:00.000
Any help Thanks.

Best Answer

A = { '2012-03-01T00:01:00.000Z'
    '2012-03-01T00:30:59.999Z'
    '2012-03-01T01:00:59.999Z'
    '2012-03-01T01:31:00.000Z'
    '2012-03-01T02:00:59.999Z'
    '2012-03-01T02:29:59.999Z'
    '2012-03-01T03:00:00.000Z'}
out = regexprep(A,{'T','Z$'},{' ',''});
Related Question