replacing blank values in a single column cell array with the previous value
    11 views (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 Characters and Strings 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!

