Character to date 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.

Answer 1

[Andrei Bobrov]

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$'},{' ',''});

[Vengatesan]

Many thanks for the quick response Andrei. It worked.

[Vengatesan]

Andrei, Just one more point. I would like to write the date/time as

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

but your solution gives '2012-03-01 00:01:00.000' '2012-03-01 00:30:59.999' '2012-03-01 01:00:59.999' '2012-03-01 01:31:00.000' '2012-03-01 02:00:59.999' '2012-03-01 02:29:59.999' '2012-03-01 03:00:00.000' Thanks.

[Andrei Bobrov]

A = {'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'};

out = cellstr(datestr(datenum(A,'dd/mm/yyyy HH:MM:SS.FFF'),'yyyy-mm-dd HH:MM:SS.FFF'));