Splitting the first cell of my table into two

1 vue (au cours des 30 derniers jours)
Noush
Noush le 26 Oct 2021
Réponse apportée : Srijith Kasaragod le 28 Oct 2021
I have a table, in which the first cell has the date and then the time stored, but like this: 20050101:0030. So what seperates date and time is the double points. I cannot import it as a date and time though, that returns me NaT instead of values. Thats why I cant apply the timeofday command.
How can I split the first column of my table, so that I get two new columns, one with the time and one with the date?
Thank you :)

Connectez-vous pour répondre à cette question.

Réponses (1)

Srijith Kasaragod
Srijith Kasaragod le 28 Oct 2021
Hi Noush,
You can separate the values using 'strsplit' function by giving delimiter argument as ':' in this case. It would return two strings, one with date and other time.
Regards.

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by