how to replace missing values from a double inside a cell array?

1 view (last 30 days)
I really thanks in advance anybody can tell me how can I replace THE missing values (100000) in the below cell array with NaN.
A = {[1,2,3,100000,4,5,100000],[6,100000,7,100000]};

Accepted Answer

JESUS DAVID ARIZA ROYETH
JESUS DAVID ARIZA ROYETH on 5 Feb 2020
newA=cellfun(@(x) x.*(x~=100000)./(x~=100000),A,'Uni',false)

More Answers (1)

BN
BN on 5 Feb 2020
Edited: BN on 5 Feb 2020
index=find(A==100000); %found 100000 in the A
A(index)=NaN; % Replace them by NaN

Categories

Find more on Characters and Strings in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by