How to separate month and year?

2 views (last 30 days)
Megan Mirkhanian
Megan Mirkhanian on 20 Jan 2020
Commented: Megan Mirkhanian on 20 Jan 2020
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.

Answers (1)

Claudio Iturra
Claudio Iturra on 20 Jan 2020
Edited: Claudio Iturra on 20 Jan 2020
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 Comment
Megan Mirkhanian
Megan Mirkhanian on 20 Jan 2020
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)

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!