Read from excel and compare text

I need to read a column from excel for example say I need to read user_id column from excel and the excel sheet is present in some other folder at desktop.after I read the column containing user_id's I need to search for a particular user_id. How do I do that ...?

Answer 1

[Walter Roberson]

readtable() to get the data into place. strcmp() or ismember() the appropriate column of the table.

[Sajid Afaque]

I need to compare the user_id's with a specific user_id and return either 1 or 0 .how do I do that

[Walter Roberson]

If the user_id are numeric:

specific_user_id == YourTable.user_id

If the user_id are character vectors:

strcmp(specific_user_id, YourTable.user_id)

If you just need to know whether the specific ID is found at all:

ismember(specific_user_id, YourTable.user_id)

If you need to know whether it is found and where it was found and there is only at most one match:

[specific_was_found, idx] = ismember(specific_user_id, YourTable.user_id);

[Sajid Afaque]

Thanks a lot walter