How to remove extra text from date and timestamp ?

Hi everyone

I have a text file which I I am imprting as an table in Matlab.

I have a timestamp like"2019-01-01T00:00:00Z" and want to remove the "T" and "Z" in it so I only have date and time and can use datenum for calculations.

Can you help me with this?

Thank you in advance

Answer 1

[Seth Furman]

We strongly recommend using datetime instead of datenum. As Star Strider mentioned, datetime allows you to specify the 'T' and 'Z' characters in the input format. If you're using readtable, you may want to consider using readtimetable, which helps avoid the extra step of converting timestamp data into datetime.

https://www.mathworks.com/help/matlab/ref/readtimetable.html

[Maryam Mohiti Ardakani]

Thank you. This solved my problem.