How do you count how many values are in an array until a given number?

6 views (last 30 days)
I have an array of values, it starts with integers then some zeros appear before finally more integers and then more zeros. I am looking to find a way to cut the array short before the second set of zeros appear.
The minimum value always occurs in column 5 of the second set of integers so I thought I could find the minimum value and cut if off there, however to do this I need to know how what row this minimum number occurs at. Ive seen in some forums that the find function may be able to be used however I cant get it to work. An extract of my script is posted below.
data = csvread(['groupC0',num2str(i),'.CSV'],6,0);
limit = find(data,min(data(:,5)))
truedata = data(1:limit,3:8);
  1 Comment
Jan
Jan on 24 Apr 2013
The text description of the inputs is not clear. Are you talking about a vector or a matrix? If it is a matrix, do the zero blocks have the same position in each row (or column?)?

Sign in to comment.

Accepted Answer

Jan
Jan on 24 Apr 2013
x = [1,2,3,4,5,0,0,0,0,4,3,2,4,2,0,0,0,0,4,3,2]; % Does this match your data?!
zeroBlockStart = strfind(x == 0, [false, true]) + 1;
Now you have the indices, where the blocks of zeros start. Does this help already?
  1 Comment
Dave
Dave on 24 Apr 2013
Thanks for your response, it was imported as a matrix but I was only looking for the maximum value in one column. I made it work by using:
data = csvread(['groupC0',num2str(i),'.CSV'],6,0);
[r minloc] = find(data==min(data(:,5)));
truedata = data(1:r,3:8);

Sign in to comment.

More Answers (0)

Categories

Find more on Operators and Elementary Operations in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!