Split individual cell into multiple cells

2 views (last 30 days)
Kate
Kate on 23 Nov 2016
Answered: Kate on 23 Nov 2016
I have a variable that I've imported into my workspace which has the following format:
TIMESTAMP
20100101
20100102
20100103
etc
How can I split the individual cells so that they are individual variables with only the year, month or day? As in: 2010
2010
2010 and
01
02
03
etc.
Thanks a bunch! K

Accepted Answer

Kate
Kate on 23 Nov 2016
Answered my own question and will post for anyone who has the same issue. datevec extracts the month and day. Example:
t=datevec(TIMESTAMP)
55004 10 29 0 0 0
55004 10 30 0 0 0
55004 10 31 0 0 0
55004 11 1 0 0 0
55004 11 2 0 0 0
Then just reference specific columns of t. As in:
Month=t(:, 2);

More Answers (0)

Categories

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

Tags

Community Treasure Hunt

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

Start Hunting!