Stuart’s MATLAB Videos

Watch and Learn

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

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.

  • print
  • send email


댓글을 남기려면 링크 를 클릭하여 MathWorks 계정에 로그인하거나 계정을 새로 만드십시오.