I need help with sort out string from Excel File to Matlab

This is the Excel part that i imported to Matlab

UserData =

4×2 cell array

{'30E92115' } {'[e-mail]''}

{'HR26DK83OO'} {'[e-mail]'' }

{'29E492114' } {'[e-mail]'' }

{'30E591255' } {'[e-mail]'' }

My Main Code

PlateNumber ='30E92115';

[~,UserData] = xlsread('userdata.xlsx','A:B');

Plate = UserData(:,1);

Email = UserData(:,2);

noPlate = numel(Plate);

for i = 1:noPlate

compare = strcmpi(Plate,PlateNumber);

if compare == 1

Email = destination;

end

end

disp(destination);

So the idea is if the strcmpi() is true, when the PlateNumber value is equal to the email follow by the '30E92115' string in the imported Excel file, the "destination" will receive the email come along with the '30E92115' , but somehow I got this error, PLEASE HELP

Unrecognized function or variable 'destination'.

Error in compare (line 13)

disp(destination);

Answer 1

[Thomas Jensen]

Hi Tran,

The script is not assigning any value to the variable "destination". That is why the line "Email = destination;" and the line "disp(destination);" can be executed.

As a good practice, always assign a value to the variables set inside a loop or if statement. For example, add a new line before " for i = 1:noPlate" with the content "destination = [];".

Best regards,

[To Tran Luan]

Thank you for reply, but I tried as you said and it still show the destination[] variable is an emty array even thought the compare() already show =1

[Thomas Jensen]

Hi Tran, Could you be more specific? Is the error still being raised? If you want to have a non-empty value for the variable "destination", you need to assign a value inside the for statement. In the script you provided, destination is never assigned inside the for statement. Maybe the if statement is not right. Shouldn't it be "destination=Email;"? Best regards,

[To Tran Luan]

I tried as your recommendation but the value of destination is still give out as emty

although the value of comp is 1 ,so the value of the second cell suppose to be equal to destination (the red markered email)

[Thomas Jensen]

Hi Tran,

Thanks for sending the screenshots.

I did some updates on your script and I think now it is working as you described.

PlateNumber ='30E92115';
[~,UserData] = xlsread('userdata.xlsx','A:B');
Plate = UserData(:,1);
Email = UserData(:,2);
noPlate = numel(Plate);
destination = [];
for i = 1:noPlate
    compare = strcmpi(Plate{i},PlateNumber);
    if  compare == 1
        destination = Email{i};
    end
end

if isempty(destination)
    disp('Email not found.');
else
    disp(destination);
end

Best regards,