Splitting the first cell of my table into two

1 次查看（过去 30 天）
Noush
Noush 2021-10-26
回答： Srijith Kasaragod 2021-10-28
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 :)

请先登录，再回答此问题。

回答（1 个）

Srijith Kasaragod
Srijith Kasaragod 2021-10-28
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.

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by