How to extract year, month, day from character vectors?

Question

Paul Barrette 2022-8-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1778045-how-to-extract-year-month-day-from-character-vectors

评论： Paul Barrette 2022-8-14

I have a character vector matrix (I think that's what it's called - it was obtained with cell2mat command applied to a *.csv file) which shows this when I open it (one column):

var =

'1970/01/01'

'1970/01/02'

'1970/01/03'

'1970/01/04'

'1970/01/05'

'1970/01/06'

I would like to produce a numerical matrix X with as many rows but three columns (year, month, day, respectively). I've explored numerous options, to no avail. Any suggestions?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kevin Holly 2022-8-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1778045-how-to-extract-year-month-day-from-character-vectors#answer_1025190

编辑：Kevin Holly 2022-8-11

在 MATLAB Online 中打开

var =['1970/01/01'
'1970/01/02'
'1970/01/03'
'1970/01/04'
'1970/01/05'
'1970/01/06']
var = 6×10 char array
    '1970/01/01'
    '1970/01/02'
    '1970/01/03'
    '1970/01/04'
    '1970/01/05'
    '1970/01/06'
% I want to make you aware of Datetime arrays
datetime(var,'InputFormat','yyyy/MM/dd')
ans = 6×1 datetime array
   01-Jan-1970
   02-Jan-1970
   03-Jan-1970
   04-Jan-1970
   05-Jan-1970
   06-Jan-1970
% Here is how you can convert your data into a numerical matrix containing Year, Day, and Month columns
m = [];
for ii = 1:size(var,1)
m = [m;split(var(ii,:),"/")'];
end
X = str2double(m)
X = 6×3
        1970           1           1
        1970           1           2
        1970           1           3
        1970           1           4
        1970           1           5
        1970           1           6