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.
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
John D'Errico
el 9 de Oct. de 2020
Editada: John D'Errico
el 9 de Oct. de 2020
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.
Respuestas (1)
Sudhakar Shinde
el 9 de Oct. de 2020
Instead of contains you can try:
- regexp
- strcmp
strcmp - could be your interest.
0 comentarios
Ver también
Categorías
Más información sobre Characters and Strings en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!