MATLAB Answers

Row position and find value

3 views (last 30 days)
I have having some trouble with locating the position of the row in a table and then using that same row to find the value in column 3.
I first used:
Accelval=find(strcmp(mergetable1{:,1},AccelSN),1) to find the value where the first column matches the variable where the user has an input. The I would like to find the row position of this value. After determining the row position, I must create a new variable that uses the row position to find the value in column 3.
Any suggestions?

  0 Comments

Sign in to comment.

Accepted Answer

madhan ravi
madhan ravi on 30 Jun 2020
Replace
Accelval
with
[rows, columns] = ... and use the rows to index the table of column 3

  2 Comments

Alexandra Philip
Alexandra Philip on 30 Jun 2020
Thank you. So, just for clarification, I would use:
[rows, columns]=find(strcmp(mergetable1{:,1},AccelSN),1)
BIA1=mergetable1{rows,3}

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!