choose string variables using ismember

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

2 Comments

i think it should be ismember(A,unique(A) ) but i need to exclude 0
Do you want to exclude ' 0' too?

Sign in to comment.

 Accepted Answer

setdiff(A,'0')

3 Comments

tahnk you.where should i put this command. inside ismember or before it?
You dont need ismember.

Sign in to comment.

More Answers (0)

Categories

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!