MATLAB Answers

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).

  0 Comments

Sign in to comment.

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

Sanket Gaikwad
Sanket Gaikwad on 30 Jun 2020
I'm getting this error when i used your solution.
"Error using regexp
All cells must be char row vectors."
Thank you for your answer.
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)

Community Treasure Hunt

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

Start Hunting!