Find if row (string) matches an array

2019 2 25
1 个回答
更新时间：2019 2 27
1 次查看（30 天）

0 个投票

Hi,
Please note I am new to Matlab and have never written a script.
I have database A with roughly 6x3000 array of strings. I have database B with a similar sized array. Only some of the rows in each database are an exact match. I want to be able to find out which rows in database B match exactly with rows in database A, and then return a yes/no.
E.g.
Database A
"pig" "stripe"
"box" "house"
"apple" "land"
"car" "bus"
"bottle" "rope"
Database B
"car" "sink"
"pig" "stripe"
"land" "car"
"bottle" "rope"
I would want the following return in the order of Database B, so that 0 means its not in Database A, and 1 means it is.
0
1
0
1
Any help GREATLY appreciated.
Thanks
Vicky

请先登录，再回答此问题。

回答（1 个）

madhan ravi
madhan ravi 2019-2-25

0 个投票

ismember(Database_B,Database_A,'rows')

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Victoria Fleming
Victoria Fleming 2019-2-26
Thanks - this returns values at the cell level only though.
I need to know if that exact row, is an exact match for a row somehwere in the second database. Is there a way of using ismember to confine to exact matches?
thanks for your help
madhan ravi
madhan ravi 2019-2-27
>> Database_A=...
["pig" "stripe"
"box" "house"
"apple" "land"
"car" "bus"
"bottle" "rope"];
Database_B=...
["car" "sink"
"pig" "stripe"
"land" "car"
"bottle" "rope"];
ismember(Database_B,Database_A,'rows')
ans =
4×1 logical array
0
1
0
1
>>
Where do you see a cell array??
Victoria Fleming
Victoria Fleming 2019-2-27
Hi,
It worked - it returned a value for every cell in the array, but as long as they are all true I can find my matching rows.
Thanks for your help.
madhan ravi
madhan ravi 2019-2-27
Are you asking a question or stating?

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Operators and Elementary Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by