Check if number in Row, if not delete the complete column

Hello, this is the Data:

TestData = {'A','B','C','D';...
            3,4,8,7;...
            4,9,5,9;...
            5,[],2,[];...
            7,[],2,[];...
            1,[],6,[]}

1. Check if in row 4 is a number

2. If not, delete the complete column where is not a number.

3. In this case this means: Delete column B and D.

The real data is very big, over 10000 rows...

How can I do this ?

[Image Analyst]

Is this homework? Sounds like it? If so, tag it as homework.

Answer 1

[goerk]

You can try this

mask = cellfun(@isempty, TestData);
deleteColumn = sum(mask)>0;
TestData(:,deleteColumn) = [];