MATLAB Answers

Read from excel and compare text

6 views (last 30 days)
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 ...?


Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 21 Mar 2019
readtable() to get the data into place. strcmp() or ismember() the appropriate column of the table.


Sajid Afaque
Sajid Afaque on 21 Mar 2019
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
Walter Roberson on 21 Mar 2019
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);

Sign in to comment.

More Answers (0)