Stuart’s MATLAB Videos

Watch and Learn

Making a MATLAB Script to Compare Two Long Lists of Strings from Excel 2

Posted by Stuart McGarrity,

I often need to compare long lists of strings, usually URLs. If I have less than a few thousand, and the data is already in Excel, I will use the MATCH and INDEX functions in Excel to do this. However, if the lists are in the order of tens of thousands or hundreds of thousands, Excel struggles. Here, I write a very simple MATLAB script to input two lists of strings from Excel spreadsheets, compare using setdiff, and intersect and write the results back.

This video uses the code-along style.

Play the video in full screen mode for a better viewing experience.

2 CommentsOldest to Newest

Vicki replied on : 1 of 2

Hi Stuart.

I’m Vicki and right now i learn about Matlab, could you please help me to give some tutorial about GUI(i mean, i try to figure out about FFT using complementary filter to find specific signal in it, and how to save it into Excel)
I really hope You can help and reply my mail.

Best regards
Vicki

Stuart McGarrity replied on : 2 of 2

I could help with a specific question, but if you need to learn MATLAB overall you should look at MATLAB Academy On Ramp: https://matlabacademy.mathworks.com/R2016a/portal.html?course=gettingstarted.

To learn Signal Processing in MATLAB try here: http://www.mathworks.com/academia/student_center/tutorials/signal-processing-tutorial-launchpad.html.

For building GUIs/apps, see here: http://www.mathworks.com/discovery/matlab-gui.html

Add A Comment

What is 3 + 6?

Preview: hide