MATLAB: Finding matching strings from a table and making a new table

Question

I have a huge table of size 18792010×57 (57) are the number of columns.

As an example say the table (T) that looks like:

'A' 'B' 'C' 'D'……'BC'

'AFG' 'NCD' 22 1….. 2

'CAN' 'NCD' 36 7……4

'AFG' 'HER' 21 3……3

'BER' 'NCD' 32 1……5

'CAN' 'HER' 31 1……3

I want to make a separtate table (T_1) just for AFG like:

'A' 'B' 'C' 'D'……'BC'

'AFG' 'NCD' 22 1….. 2

'AFG' 'HER' 21 3……3

I am using readtable function to read the table and the used the below line but it returns an error –> 'Undefined operator '==' for input arguments of type 'cell'

T_1 = T(T.A == 'AFG')

Answer 1

T_1 = T(strcmp(T.A, 'AFG'), :);