replacing blank values in a single column cell array with the previous value
1 view (last 30 days)
Show older comments
basically i have a list of values in a cell array.
A =
'-2.0372681e-10'
'0'
'-1.1641532e-10'
'-2.910383e-11'
' '
' '
'-1.45579e-11'
'0'
' '
'2.9103759e-11'
' '
'1.455188e-11'
'-2.910383e-11'
'7.2759396e-11'
'-1.45579e-11'
'2.9103759e-11'
'-4.3655746e-11'
'8.7311276e-11'
I want all the blanks to be filled with whatever the previous cell value is
1 Comment
Accepted Answer
Andy
on 19 May 2011
Pending the answer to Sean de's comment, I will assume the first entry is not blank:
for ix=2:length(A)
if isempty(A{ix})
A{ix} = A{ix-1};
end
end
EDIT: As per Sean de's suggestion, the for loop now starts at 2. Michael, you may have to adjust this if the first element is allowed to be blank. (The code will not cause an error, but the result will not be what you intended.)
1 Comment
Sean de Wolski
on 19 May 2011
This is probably just as good as any vectorized solution since we're dealing with cell arrays. +1!
More Answers (0)
See Also
Categories
Find more on Matrices and Arrays 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!