Need to find rows with specific strings

I am pulling data in from an excel file and need to check which rows contain a specific string of text

data =7150x1 string

I need to know which rows contain 'xyz'

strfind() returns Search term must be a text or pattern scalar

Contains returns just a 0

[Image Analyst]

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[Dyuman Joshi]

As mentioned, unless we have the file to test what happens, it is difficult to suggest anything.

Please share the file you are working with. Use the paperclip button to attach.

Edit -

"Contains returns just a 0 "

@Charles, Could you elaborate on this? Does it return just a 0? Or all 7150 values are 0?

Answer 1

[Walter Roberson]

mask = contains(data, 'what you are looking for');

selected_data = data(mask);