Read from excel and compare text
조회 수: 1 (최근 30일)
이전 댓글 표시
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 ...?
댓글 수: 0
채택된 답변
Walter Roberson
2019년 3월 21일
readtable() to get the data into place. strcmp() or ismember() the appropriate column of the table.
댓글 수: 3
Walter Roberson
2019년 3월 21일
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);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!