I need to extract a row that coincides with a number in the first column.

1 view (last 30 days)
Based on a number in column a, need to fill the rest of the row with the coinciding information.
  3 Comments
Image Analyst
Image Analyst on 31 May 2016
Actually there is not even a question here. Just an announcement. If you decide to ask a question, please read this first.
Jeff
Jeff on 1 Jun 2016
Sorry guys, though I can usually figure this stuff out, I am not up on all the proper language to use. I am a simpleton with a skill above what it should be, I will try this and get back with you.

Sign in to comment.

Answers (1)

Roger Stafford
Roger Stafford on 31 May 2016
I agree with Cyclist’s comment as to the lack of clarity in your request, but I will take a very wild guess as to what you are asking. You have an array in which the values in the first column can be regarded as row indices, and that means they must be positive integers not exceeding the number of rows. You wish to replace columns (other than the first column?) by the elements that are currently in the row corresponding to that first column value if it is regarded as a row index.
Let A be your array.
A = A(A(:,1),:);
Or perhaps if you don’t want the first column values to change, you mean this:
A(:,2:end) = A(A(:,1),2:end);

Community Treasure Hunt

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

Start Hunting!