Removing NaN from cell array

I have cell array which ends with NaN as last row

'Mat Name'    'MAT Type'      'E1'  
  'GFRP'        'GFRP'        'GFRP'
  'CFRP'        'CFRP'        'CFRP'
  'KFRP'        'KFRP'        'KFRP'
  'SCDB'        'SCDB'        'SCDB'
  'ABCD'        'ABCD'        'ABCD'
  [NaN]          [NaN]        [ NaN]

How to remove the NaN from the last row of cell array

thanks in advance

Answer 1

[Honglei Chen]

x = {'xy','yz',nan}
x(cellfun(@(x) any(isnan(x)),x)) = []

[Thulasi Durai Durai Samy]

Hello Thanks for your response i tried this command but the following error occurred

raw(cellfun(@isnan,raw)) = [] ??? Error using ==> cellfun Non-scalar in Uniform output, at index 1, output 1. Set 'UniformOutput' to false.

[Ryan]

try:

x(cellfun(@isnan,x,'UniformOutput',false))

[Honglei Chen]

I've updated the answer

[Thulasi Durai Durai Samy]

Its works for the array x which you shown but for the cell array

'Mat Name'    'MAT Type'      'E1'  
  'GFRP'        'GFRP'        'GFRP'
  'CFRP'        'CFRP'        'CFRP'
  'KFRP'        'KFRP'        'KFRP'
  'SCDB'        'SCDB'        'SCDB'
  'ABCD'        'ABCD'        'ABCD'
  [NaN]          [NaN]        [ NaN]

its is not working, kindly help

[Honglei Chen]

Add

reshape(x,[],3)

after you run the command in my answer

[Thulasi Durai Durai Samy]

!!wonderfull!! wow its work well, what is the logic behind it

[Honglei Chen]

cellfun will loop each cell for you to check whether a cell is nan or not, but it does not preserve the dimension. So you need to reshape it back at the end.

[Jan]

Another approach, which remove all non-strings: x = x(cellfun('isclass', x, 'char'))