How do you search a file for a matching string?

1 vue (au cours des 30 derniers jours)
Vinay kumar Reddy
Vinay kumar Reddy le 2 Fév 2013
Hi,
I have a huge contacts list in a excel file which consists of following fields
FirstName LastName UserID EmailAddress.
I have FirstName and LastName in MATLAB as a variable.
How do I extract the user ID and EmailAddress for a corresponding FirstName and LastName?
Note:There are some 50,000 contacts in Excel file.

Connectez-vous pour répondre à cette question.

Réponse acceptée

Azzi Abdelmalek
Azzi Abdelmalek le 2 Fév 2013
[num,text,v]=xlsread('yourfile')
s1='firstname';
s2='lastname';
idx=find(strcmp(v(:,1),s1) & strcmp(v(:,2),s2)
Id=v(idx,3)
Email=v(idx,4)

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by