Asked by Staf
on 14 May 2012

Dear all,

I have produced the following output

county interst rate

England b1

England b1

England b1

England b1

England b2

England b2

England b2

England b3

England b3

England b4

England b4

The above table says that for England we have different types of interest rate. I would like to select the values of interest rates that correspond to both bi and b2.

If I use the command

strcmp(mdata1(:,2),'b1')

i select only b1. But I want to select both b1 and b2 Any suggestions?

thanks in advance,

stef

*No products are associated with this question.*

Answer by Titus Edelhofer
on 14 May 2012

Accepted answer

Hi Stef,

I guess you are looking for ismember:

ismember(mdata(:,2), {'b1' 'b2'})

Titus

Staf
on 14 May 2012

Hi Titus,

It worked!. thank you so much. I would like to ask you something relevant to the previous question. Apart from the above columsn I have also another column that takes numerical values but has the following structure

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[8]

[8]

[8]

[8]

[ 7]

[ 7]

[ 7]

[ 0]

[ 0]

Again, I want to select b1 and b2 from the column

"interest rate ínterest" AND the number 7 and 0 from the above column so as to find the corresponding values of interest rates.

I was thinking something like

ismember(mdata(:,2), {'b1' 'b2'}) & something else" "

but i do not know what this "something else" is. your help is greatly appreciated

Answer by Staf
on 14 May 2012

Hi Titus,

It worked!. thank you so much. I would like to ask you something relevant to the previous question. Apart from the above columsn I have also another column that takes numerical values but has the following structure

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[10]

[8]

[8]

[8]

[8]

[ 7]

[ 7]

[ 7]

[ 0]

[ 0]

Again, I want to select b1 and b2 from the column "interest rate ínterest" AND the number 7 and 0 from the above column so as to find the corresponding values of interest rates.

I was thinking something like

ismember(mdata(:,2), {'b1' 'b2'}) & something else" " but i do not know what this "something else" is. your help is greatly appreciated

Comment on this Answer

Titus Edelhofer
on 14 May 2012

The values you have seem to be a cell array. Convert it to a double array:

doubleArray = cell2mat(cellArray);

Then you can use it lile

ismember(mdadata(:,2), {'b1' 'b2'}) & (doubleArray==0 | doubleArray==7)

Opportunities for recent engineering grads.

## 0 Comments