I have a Matrix A =
'30' 'X' '@NA' '15' 'Y' [231.001] '00' 'Y' [21.110] '20' 'W' '@NA' '55' 'X' [9.001] '10' 'X' [11.211] >>whos A Name Size Bytes Class Attributes aaa 6x3 226 cell
How can I get a new matrix B that delete the whole row of Matrix A if there is anything other than '10','15','20'…'55' in Column 1, or any '@NA' in Column 3 , and MERGE the next qualified row.
Take A for example, Row 1 and 4 should be deleted because there is '@NA' in Column 3. Row 3 should also be deleted because there is '00' in Column 1.
Matrix B should like,
>>B B = '15' 'Y' [231.001] '55' 'X' [9.001] '10' 'X' [11.211]
B is a 3*3 cell matrix. Any suggestion is welcome!
Best Answer