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

3 visualizzazioni (ultimi 30 giorni)
Andrew Green
Andrew Green il 29 Lug 2020
Commentato: Steven Lord il 29 Lug 2020
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
  1 Commento
KSSV
KSSV il 29 Lug 2020
You have many functions to read that format...you need not to change it..read about datestr, datetime, datenum, datevec.

Accedi per commentare.

Risposte (1)

Stephen23
Stephen23 il 29 Lug 2020
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
  1 Commento
Steven Lord
Steven Lord il 29 Lug 2020
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)

Accedi per commentare.

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by