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
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .Select web site
You can also select a web site from the following list:
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.