Save sub-matrix column and row in another matrix

I have a 2D array with 4 column and many rows.

   Month   Day   Year     Value

   xx      xx    xxxx    xxx.xxxx

I want to enter the year from keyboard then save in an other matrix all the rows (month, day,year,value info) that contain the year from the input I entered. I've tried this

for idx = 1:numel(array)
    element = array(idx);

      if(element == month)
          ..... "Don't know how to do..."
      end

end

thank you in advance

Answer 1

[KL]

your_result = your_array(your_array(:,3)==your_choice_year,:);

but an efficient way to store such data is to use a table.

https://de.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html

To create a table,

 T = array2table(your_array, 'v',{'month','day','year','val'})

to extract year,

 res = T(T.year==your_choice,:)

same goes for month or day

[giasco]

I'm working with tables now. Is it possible to extract month and year at the same time?

Something like

   res = T(T.year==1995,:) & T(T.month==1,:)

Answer 2

[Andrei Bobrov]

Let a - your array [Month Day Year Value]

out = a(a(:,3) == input_year,:);

[giasco]

It works great. And if I want to extract month and year ?