How to separate month and year?

1 次查看(过去 30 天)
Hi,
I have two columns of
  1. year and month data
  2. sand data
The year and month data looks like this 199701, so I want to make a column for the month 01 and a seperate column for the year 1997.
How will I seperate this.

回答(1 个)

Claudio Iturra
Claudio Iturra 2020-1-20
编辑:Claudio Iturra 2020-1-20
Hello, you can run the follow example, using num2str to create a string, choose specific element of your vector and then go back with str2num.
x = [199701 199702]' % your time vector yyyyday
x = num2str(x)
year = x(:,1:4)
day = x(:,5:end)
year = str2num(year)
day = str2num(day)
year =
1997
1997
day =
1
2
  1 个评论
Megan Mirkhanian
Megan Mirkhanian 2020-1-20
Perfect, thank you. So I see you can do it individually, but how will I change that for the entire first column of my data. Seperating the first oclumn into two (month and year)

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Data Type Conversion 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by