How to separate month and year?

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.

Answer 1

[Claudio Iturra]

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

[Megan Mirkhanian]

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)