Is there a way to take a table of values and return a new table with only the rows that have data of a specified value?

For example, lets say I have a table that contains two rows:

1,2,3,4,5

5,6,7,8,9

Is there a way to, if given the number 4, return a new table with only the first row: 1,2,3,4,5 in it?

Answer 1

[Walter Roberson]

If you mean "array" instead of table() objects, then

YourArray( any(YourArray == 4, 2), :)

[Tyler Johnson]

I mean a table where a variable is assigned to each column and each row has equal length. Or is it only possible to extract columns at a time from this type of table?

Answer 2

[Image Analyst]

Here is one way:

% Create table variable
columnNames = {'Col1', 'Col2', 'Col3', 'Col4', 'Col5'}
t = table([1;5], [2;6], [3;7], [4;8], [5;9], 'VariableNames', columnNames)
% Scan rows keeping track of which rows have a 4 in them.
for row = 1 : size(t, 1)
  rowsWith4(row) = any(t{row, :} == 4, 2);
end
% Extract only rows with 4 in them.
newTable = t(rowsWith4, :)

You'll see

t = 
    Col1    Col2    Col3    Col4    Col5
    ____    ____    ____    ____    ____
    1       2       3       4       5   
    5       6       7       8       9   
newTable = 
    Col1    Col2    Col3    Col4    Col5
    ____    ____    ____    ____    ____
    1       2       3       4       5