Filter löschen
Filter löschen

converting date and time string to datetime object

8 Ansichten (letzte 30 Tage)
Salma fathi
Salma fathi am 30 Mär. 2022
Kommentiert: VBBV am 30 Mär. 2022
I am trying to read several text files each has 4 variables, the first coumn has the date and time values otgether in the following format
''2022-02-16T15:50:00.000Z'', and I would like to convert them in the following format "20220216155000".
I would like to convert theis into a datetmir object so i can use these vaues to compare to other dates and times from a different tables.
I am using the following lines for converion
for x = 1:length(Ionotable.x_Time) %x_Time is the column where the date and tie values are stored
Ionotable(x,1) = datetime(string(x),'InputFormat','yyMMddHHmmss');
end
but I am getting the follwoing error
Error using datetime (line 651)
Unable to convert '1' to datetime using the format 'yyMMddHHmmss'.
Error in Ionosonde_Data (line 23)
Ionotable(x,1) = datetime(string(x),'InputFormat','yyMMddHHmmss');

Akzeptierte Antwort

VBBV
VBBV am 30 Mär. 2022
Bearbeitet: VBBV am 30 Mär. 2022
k = 1;
while k<=length(Ionotable.x_Time)
x = (Ionotable.x_Time(k)) %x_Time is the column where the date and tie values are stored
Ionotable(k,1) = datetime(string(x),'InputFormat','yyMMddHHmmss');
k = k+1;
end
  5 Kommentare
Salma fathi
Salma fathi am 30 Mär. 2022
thank you problem solved.
VBBV
VBBV am 30 Mär. 2022
Please accept the answer if it solved. :) thanks

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Dates and Time finden Sie in Help Center und File Exchange

Produkte


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by