Splitting the first cell of my table into two
2 次查看(过去 30 天)
显示 更早的评论
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 :)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/779003/image.png)
回答(1 个)
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.
0 个评论
另请参阅
类别
在 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!