To put value in the specific column of uitable

A uitable is constructed like this:
a=[1 2 3 0;1 2 4 5;0 9 7 0;1 3 4 6]; a=num2cell(a)
First the matrix is like this:
1 2 3 0
1 2 4 5
0 9 7 0
1 3 4 6
Therefore I need to construct the code based on the algorithm below:
1.In first row, I need to check either the value in end column is zero or not. If the value is zero,I need to shift the end column into previous column. If the element is zero again,the operation will proceed again, else the end column will fix.
2. In the end column, the value 55 will replace the current value.
3. This process will proceed to next row.
Finally,the matrix will become like this:
1 2 55 0
1 2 4 55
0 9 55 0
1 3 4 55
I need help to solve this problem. Thank you very much for your concern.

4 Comments

I don't see what this has to do with Genetic Algorithm and Direct Search Toolbox ??
When you say that the elements are to be shifted, do you mean a circular shift, in which all the columns move one place to the left and what was the former first column moves to the last column? If so then see circshift()
No, actually, I don't want to shift the column,but I want to change the value of end column in each row if the column contained value. If the end column of each row has 0 value, therefore the end column will transfer into the second last column. The end matrix will become like this :
1 2 55 0
1 2 4 55
0 9 55 0
1 3 4 55
Forgive me for my fuzzy question.
So the rule is just "Change the last non-zero entry in the column to the value 55" ?

Sign in to comment.

 Accepted Answer

s = size(a);
j1 = arrayfun(@(x)find(a(x,:),1,'last'),1:s(1));
a(sub2ind(s,1:s(1),j1)) = 55;
OR if a - cell array
a1 = cellfun(@(x)x>0,a);
a(fliplr(cumsum(a1(:,end:-1:1),2))==1 & a1) = {55};

More Answers (0)

Community Treasure Hunt

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

Start Hunting!