How to use contains method to find indices for only certain strings. For example, I have RA-IS1 and RA-IS1-CRT, but I only want to find RA-IS1 indices.
2 次查看(过去 30 天)
显示 更早的评论
Hi! I have two excel sheets, and I am trying to find the indices where a certain string from one sheet is contained on the other sheet using the contains method. Some of the strings contain parts of other strings, but also more characters. For example, I have strings RA-IS1 and RA-IS1-CRT. Currently, if I look for the indices where RA-IS1 is contained it will also give me the indices where RA-IS1-CRT is contained. How do I get the contains indices for only the smaller string?
1 个评论
John D'Errico
2020-10-9
编辑:John D'Errico
2020-10-9
Since contains gives you either case, then even though you want to use contains, you cannot do so.
"If your only tool is a hammer, then every problem looks like a nail."
The implication being, you need to learn how to use other tools. Perhaps you are looking to test for exact equality. You may wish to consider other tools, perhaps regexp. Or perhaps you need to test the strings you do find using contains to see if more is present in the string.
回答(1 个)
Sudhakar Shinde
2020-10-9
Instead of contains you can try:
- regexp
- strcmp
strcmp - could be your interest.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!