How to search a table inside a cell

I have been given a workspace that has a cell variable that is 1x10 inside each cell is a table that is 100x16. Each column in each table has the same var names (time, rpm, temp, p1, p2, etc...).

I want to search the table in data(1,1) to find the first time what the temp is 300, but cannot figure out how.

[Rik]

What have you tried? Have a read here and here. It will greatly improve your chances of getting an answer.

[Jason Burke]

I cannot find the syntax to access the table from the cell. The table that I want is at a(1,1) but when I try to look at the table I cannot figure that out.

[Adam Danz]

Access the cell using curly brackets.

Access a column variable in a table using dot-notation.

C{i}.var

Answer 1

[Tejas]

Hello Jason,

To determine the time value for a specific temperature, consider these steps:

• Begin by accessing the initial table located in the cell array.

    firstTable = data{1,1};

• Use the 'find' function to locate the index of the first occurrence of the target temperature value. More information on the function, can be found in this documentation: https://www.mathworks.com/help/matlab/ref/find.html .

    index = find(firstTable.temp == 300, 1, 'first');

• Retrieve the time value at the identified index using the provided syntax.

    timeAtTemp300 = firstTable.time(index);