Replace missing cell entries without replacing whitespaces.

23 次查看（过去 30 天）
Niek W
Niek W 2021-4-7
评论： Niek W 2021-4-7
I'm reading an excel file using readcell, and all empty cells are imported as 'missing'.
I would like to replace the missing, and i found the following suggestions (cellfun+anonymous function)
https://www.mathworks.com/matlabcentral/answers/473295-how-to-replace-missing-values-in-a-cell-array
https://www.mathworks.com/matlabcentral/answers/464998-readcell-is-filling-cell-locations-with-1x1-missing
However, this solution also marks whitespaces as missing and replaces them
A = {1, 'test123', 2, 1, 'texthere';2, 'test456', 3 ,4, missing;...
3, 'test789', missing, 1, 'text with spaces'}
A(cellfun(@(x) any(ismissing(x)), A)) = {'REPLACED'}
In this example, I would like 'text with spaces' to be left alone, and only to replace the actual 'missing' cells. How do I achieve this?
Thanks!

请先登录，再回答此问题。

采纳的回答

Niek W
Niek W 2021-4-7
Solved by rinkert: https://stackoverflow.com/questions/66985871/matlab-replace-missing-cell-entries-without-replacing-whitespaces
A(cellfun(@(x) isa(x,'missing'), A)) = {'REPLACED'}

更多回答（1 个）

Monika Jaskolka
Monika Jaskolka 2021-4-7
for i = 1:numel(A)
if ismissing(A{i})
A{i} = 'REPLACED';
end
end
  1 个评论
Niek W
Niek W 2021-4-7
Hi Monika, your solution works. However someone on stackexchange was slightly faster, so I've marked that answer as Accepted.
Thanks anyway!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by