Splitting the first cell of my table into two

Question

Noush 2021-10-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1571873-splitting-the-first-cell-of-my-table-into-two

回答： 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 个评论
显示 -1更早的评论隐藏 -1更早的评论

KSSV 2021-10-26

Read about strsplit

请先登录，再进行评论。

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

Answer 1

Srijith Kasaragod 2021-10-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1571873-splitting-the-first-cell-of-my-table-into-two#answer_818783

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.