choose string variables using ismember

Question

0 个投票

Hi all,

I have the column

A=

    '0'
    '0'
    'uk'l1'
    'ukl1'
    'ukl1'
    'ukl1'
   'ukl2'
    'ukl2'
     '0'
    '0'
    'Grl1'
    'Grl1'
    'Grl1'
    'ukl1'
   'Grl2'
    'Grl3'
     'Grl4'
     '   0'
   'Gerl1'
    'Gerl1'
      'Gerl2'
    'Gerl3'
     'Gerl4'

i want using the command similar to the below one

ismember(A,{'} )

to choose all the elements of A apart from zero. so it should be something like

ismember(A,{'ukl1' 'ukl2' 'ukl3' 'ukl4' 'ukl5' and so forth ...) )

but the problem is that A in my daraset is 8000 by 1 and contains many string variables (ukl1, ukl2,...,) so it would be very tiring to write by hand all these string variables into ismember. I would also like to mention that for example the first two letters of say, 'ukl1'denote the country (uk) and the last two the location (location 1, location 2, location3,...) thanks