Monday, November 10, 2014

Downfall of Parsing in Google Sheets

With the start of college basketball rapidly approaching, I went through to set up my model for the new season. In doing so I checked for errors (probably the most intensive and frustrating part of writing code), and found that ESPN's schedules had changed the names of certain colleges, slightly. Every "State" is changed to "St", with the exception of a few, including Ohio State, NC State, and Iowa State. Those alterations and the rest are as follows:


Bryant UniversityBryant
Boston UniversityBoston Univ.
Massachusetts LowellUMass Lowell
American UniversityAmerican
St. Peter'sSaint Peter's
Florida InternationalFlorida Int'L
St. Francis USt. Francis (Pa)
Ohio StateOhio State
Mount St. Mary'sMt. St. Mary's
North Carolina StateNC State
Southern MethodistSMU
North Carolina-WilmingtonUNC Wilmington
Cal State NorthridgeCs Northridge
CharlestonCollege Of Charleston
Prairie View A&MPrairie View
USC UpstateSouth Carolina Upstate
Southeast Missouri StateSE Missouri St
Illinois-ChicagoUIC
Boise StateBoise State
Mississippi Valley StateMiss Valley St
Penn StatePenn State
Southeastern LouisianaSE Louisiana
Virginia MilitaryVMI
Brigham YoungBYU
CitadelThe Citadel
Cal State FullertonCs Fullerton
Kent StateKent State
Iowa StateIowa State
Weber StateWeber State
Southern UniversitySouthern
Texas-ArlingtonUT-Arlington
Texas StateTexas State
Nebraska-OmahaOmaha
UTSAUT San Antonio
Tennessee-MartinTenn-Martin
Utah StateUtah State
Idaho StateIdaho State
Texas-Pan AmericanUT Pan American
Cal State BakersfieldCsu Bakersfield
Ball StateBall State
Louisiana-MonroeUL Monroe
San Jose StateSan José St
Louisiana-LafayetteUL Lafayette
Mississippi Valley StateMissouri Valley

Why ESPN, why. Parsing and error checking...

No comments:

Post a Comment