Need a kind soul for help, Changing Cell array data with greater value into another cell array.

Hello I am very confused and have been using over 5 hours to figure 1 simple task out in matlab.

it is to move or Copy the numbers higher than 230 into a new Column. file attached

here is the data. i can make the data to be either String or Double. so Either works.

please help so the numbers larger than 230 is copied in column next to it. this is so i can make a plot.

thanks alot

[Image Analyst]

Were the people who answered your question in the 4 other postings of this question not kind enough?

Answer 1

[Joseph Cheng]

simple enough,

I would suggest using the find() function.

for example:

over230 = find(V>230); %get the index of V where the values are over 230.
V=[V zeros(length(V))]; %need some zero padding as the length of over230 is shorter than V.
V(1:length(over230),2) = V(over230); %copy values V(over230) into second column

[Joseph Cheng]

If you don't really need it in the second column why not create another variable (such as my over230) so you don't have the zero padding. once you have over230,

Vover230 = V(over230);

with this you just extract the values of V>230 into a new variable.

[awda]

but this creates another cell, with triple as much data. starting at 1 ending at the value of 11000 which my highest Voltage is 233 or something.

and the errors:

Out of memory. Type HELP MEMORY for your options.

Error in test1 (line 36) V=[V zeros(length(V))]; %need some zero padding as the length of over230 is shorter than V.

Have u tried to run the data i uploaded into ur matlab? maybe my matlab is new or i dont know

[Joseph Cheng]

I have ran your V.mat and i have no issue. I would say since it is a memory issue you probably want to switch to 64 bit Matlab if you can. Since all you said was to copy values to second column you did not specify anything more I supplied a solution with very little information. So you still want to keep time sensitive values to your plots yet keep the memory down of only values over 230. Then why don't you try this very simple solution

figure,plot(over230,V(over230))

Answer 2

[awda]

By the way when you use the function called find(). u will get the matlab to start from 1 and count upto the value the cell array has. so its not an option?