convert period (.) to colon (:) for reading time

Question

Andrew Green 2020-7-29

评论： Steven Lord 2020-7-29

Hi,

I have imported some data that includes a time stamp but the way it writes it's date and time is "yyy-MM-dd HH.mm.ss"

Is there any way to convert the period (.) to a colon (:) so that matLab reads the time better?

Cheers,

Andy

KSSV 2020-7-29

You have many functions to read that format...you need not to change it..read about datestr, datetime, datenum, datevec.

Answer 1

Stephen23 2020-7-29

I don't see why you need to convert any characters, MATLAB imports that format without error:

>> str = '2020-07-29 14.42.32';
>> dtm = datetime(str,'InputFormat','yyyy-MM-dd HH.mm.ss')
dtm = 
   29-Jul-2020 14:42:32

Steven Lord 2020-7-29

You can get MATLAB to show the resulting datetime in that form as well if you want.

 str = '2020-07-29 14.42.32';
 F   = 'yyyy-MM-dd HH.mm.ss';
 dtm = datetime(str, 'InputFormat', F, 'Format', F)