Setting mixed table data as empty

I have a table of mixed data, strings and doubles, and I need the ability to set particular entries as empty. Now as each column is of a different data type I can only imagine I must make a big clunky conditional to check the datatype of the column and find out the relevant empty value to set (NaN, '', etc.). Is there an easier way I've missed here? It feels like something that should be easy to do. I have come across standardizeMissing() but it doesn't seem to like wildcards or regex.

Answer 1

[Azzi Abdelmalek]

% -----------Example-------------------
y={1 2 '3';4 [] 'r';7 5 'ee' ; 4 [] '8'}
a=cell2table(y)
%--------------The code---------------------
b=table2cell(a)
b(cellfun(@isempty,b))={nan}
y=cell2table(b)

Answer 2

[Peter Perkins]

Callum, it's possible that passing things like isnumeric into varfun as the 'InputVariables' parameter would help, although I'm not entirely sure what you mean by "particular entries".