How to make two column vectors from cell vector with space delimiter?

1 view (last 30 days)
I've one cell vector (3000by1) and I'm trying to make this into two column vectors.
C= '2020-06-29 11'
'2020-06-29 11'
'2020-06-29 11'
'2020-06-29 11'
'2020-06-29 11'
I want to seperated date and hour (11 is hour value here).

Accepted Answer

madhan ravi
madhan ravi on 30 Jun 2020
S = regexp(C, '\s', 'split');
s = cat(1, S{:});
datE = s(:,1)
HouR = s(:,2)
  3 Comments
madhan ravi
madhan ravi on 30 Jun 2020
C= {'2020-06-29 11'
'2020-06-29 11'
'2020-06-29 11'
'2020-06-29 11'
'2020-06-29 11'}
S = regexp(C, '\s', 'split');
s = cat(1, S{:});
datE = s(:,1)
HouR = s(:,2)
C =
5×1 cell array
{'2020-06-29 11'}
{'2020-06-29 11'}
{'2020-06-29 11'}
{'2020-06-29 11'}
{'2020-06-29 11'}
datE =
5×1 cell array
{'2020-06-29'}
{'2020-06-29'}
{'2020-06-29'}
{'2020-06-29'}
{'2020-06-29'}
HouR =
5×1 cell array
{'11'}
{'11'}
{'11'}
{'11'}
{'11'}
Sanket Gaikwad
Sanket Gaikwad on 30 Jun 2020
Thank you very much, it worked. The data I was working on had different last two rows. I guess that was the reason it was showing me that error.

Sign in to comment.

More Answers (0)

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!