MATLAB: Save sub-matrix column and row in another matrix

Question

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

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