Stuart McGarrity, MathWorks
(Originally posted on Stuart's MATLAB Videos blog.)
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.
Recorded: 2 May 2016