Add row to an empty array if a condition is fulfilled
4 views (last 30 days)
Show older comments
Hi everyone,
I have a 5 x 3 array and I have to make a code that checks row by row if the third column fulfills a condition. (In this case, the third column should be equal to the letter "A").
When there's an "A" in the third column, I have to take all that row and place it in a new array and this new array should have all the rows that fulfill the condition.
Edit:
And if I were to do it with a database that I have on Excel, how do I do it?
The column that has the condition that I need is the number 74, that's called "Usar". I tried it with the logical indexing but it showed me nothing.
0 Comments
Accepted Answer
James Tursa
on 21 Apr 2021
Edited: James Tursa
on 21 Apr 2021
No need for an explicit loop. Just use logical indexing:
result = m(strcmp(m(:,3),'A'),:);
0 Comments
More Answers (0)
See Also
Categories
Find more on Matrix Indexing in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!