Position and extraction of row

5 次查看(过去 30 天)
I am having some trouble find the position of the row within a table. I first did:
[rows,columns]=find(strcmp(mergetable1{:,1},AccelSN),1) to try to find where the user input variable(AccelSN) matches a number in the 1st column and then to find the row where the values match.
I use BIA0=mergetable1{rows,2} to extract the value in the same row extracted in the previous line and in the 2nd column.
I get an output of:
rows =
[]
and
BIA0 =
0×1 empty double column vector
Any suggestions to obtain the row and get an extracted value from the column of that row?

采纳的回答

Star Strider
Star Strider 2020-7-1
It would definitely help to see what ‘mergetable1’ is, and how you are getting ‘AccelSN’.
If ‘AccelSN’ is read as a string (for example from inputdlg), use the str2double function to get it as a number, since the first column of ‘mergetable1’ is apparently numeric.
For example:
mergetable1 = array2table(randi(9, 10, 3)) % Create Table (To Test Code)
AccelSN = {'4'}; % From ‘inputdlg’
AccelSN = str2double(AccelSN); % Convert To Numeric
BIA0 = mergetable1{AccelSN == mergetable1{:,1},2}
Col_3 = mergetable1{AccelSN == mergetable1{:,1},3}
Please test that with your table and code, since I cannot.
.
  3 个评论
Alexandra Philip
Alexandra Philip 2020-7-1
I was able to get the code to work. Thank you.
Star Strider
Star Strider 2020-7-2
As always, my pleasure!
(It would have helped significantly to have your table and code.)

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Testing Frameworks 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by