Split datetime column data into two column

3 views (last 30 days)
Rabia Hakim
Rabia Hakim on 21 Dec 2020
Commented: J. Alex Lee on 22 Dec 2020
Hi, i have csv file and i want to split my 4th column (DateAndTime) into two column . one column should occupy date and other is time

Answers (1)

J. Alex Lee
J. Alex Lee on 21 Dec 2020
if you import it as a datetime variable, you can use datetime operations to render into whatever format you want, including one for date and one for time.
  2 Comments
J. Alex Lee
J. Alex Lee on 22 Dec 2020
then you will not be able to manipulate in matlab...try going through the file manually and adding a comma between the date and the time.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!