Position and extraction of row

Question

Alexandra Philip 2020-7-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/558040-position-and-extraction-of-row

评论： Star Strider 2020-7-2

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2020-7-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/558040-position-and-extraction-of-row#answer_459712

在 MATLAB Online 中打开

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}