string in excel file

Hi,

How can I find out if a certain word, e.g. 'oranges' is contained within an excel sheet? I can't use ismember as for some reason, the string has to be stored in a vector.

Thanks :)

Answer 1

[Image Analyst]

Not sure why you can't use ismember. Did you try readcell, strfind, and contains?

[Davindra Usov]

Thank you for your reply. My table is a 30x300 table full of strings/chars. I tried to use: contains(g,'LATITUDES'), where g is the table but I get this error: Error using contains

Search term must be a text or pattern array.

I thought my search term is already text?

[Image Analyst]

The search term is a string but g is a table.

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

[Davindra Usov]

Hi,

So i've managed to fix it my converting the table to an array. Then used 'find' to locate the indices. However, I'm now stuck on using readtable to read in an excel file with multiple sheets. I can't attach my code as it's confidental. The amount of info I've given is what's allowed but I can't send the code itself :(

[Davindra Usov]

Also, thank you very much for your response