Need to find rows with specific strings

Question

0 个投票

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

2 个评论
显示无隐藏无

Image Analyst 2024-1-18

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

Dyuman Joshi 2024-1-20

编辑：Dyuman Joshi 2024-1-22

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 2024-1-20

编辑：Walter Roberson 2024-1-20

0 个投票

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