Deleting Zero Rows - Matlab Noob

27 views (last 30 days)
Mark
Mark on 28 Mar 2013
Edited: Dattaprasad Sh on 20 Feb 2020
I have a matrix A where the first column consists of unique positive whole numbers and zeros. I want to delete the rows where the values are zero.
A = csvread('Truss Data.csv',1,0);
B = sortrows(A(:,1:7)); %I'm sorting them to make sure they are sequential%
A =
1 0 0 0 0 1 1 1 29000 10 1 2
2 30 0 0 -120 0 0 2 29000 10 2 3
3 60 0 0 0 0 0 3 29000 10 3 4
4 90 0 0 0 0 1 4 29000 10 1 5
5 30 40 90 0 0 0 5 29000 10 2 5
6 60 40 0 0 0 0 6 29000 10 3 5
0 0 0 0 0 0 0 7 29000 10 3 6
0 0 0 0 0 0 0 8 29000 10 4 6
0 0 0 0 0 0 0 9 29000 10 5 6
B =
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
1 0 0 0 0 1 1
2 30 0 0 -120 0 0
3 60 0 0 0 0 0
4 90 0 0 0 0 1
5 30 40 90 0 0 0
6 60 40 0 0 0 0
How do I remove the rows in B where the first column of B has zeros? I want:
B =
1 0 0 0 0 1 1
2 30 0 0 -120 0 0
3 60 0 0 0 0 0
4 90 0 0 0 0 1
5 30 40 90 0 0 0
6 60 40 0 0 0 0
  1 Comment
Mark
Mark on 28 Mar 2013
*Note - the above matrix A doesn't show correctly on this webpage. There were too many columns to fit.

Sign in to comment.

Accepted Answer

Cedric
Cedric on 28 Mar 2013
B(B(:,1)==0,:) = [] ;

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!