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.

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!