Im scraping soccer information from 5 different sources for my fantasy league. Problem is that most team names can be written in many different ways with a slight difference. I've started on a very daunting task where I have in my data sheet Column AR whats supposed to be final rename of the team, then I use Vlookup in my script to try to find this team name in the data sheet. Here is a sample of my work
Vitoria Guimaraes Guimaraes Vitoria Guimaraes FC Vitoria Guimaraes Guimaraes AEskilstuna AFC Utd Eskilstuna City AFC Eskilstuna Eskilstuna City Malmo FF Malmø FF Malmo Malmø Malmo Levante UD FC Levante UD Levante FC Levante Levante TSV Hartberg TSV Hartberg Hartberg Hartberg Hartberg Legia Warsaw Legia Warsaw Legia Warszawa Legia Warszawa Legia Warsaw Norwich City Norwich Norwich City FC Norwich City Norwich
For the most part there are just some slight variation from site to site , although some names could be quite different
Does anyone have a better solution/suggestion to help automate this process as much as possible, In my code I try to remove stuff like FC , FK, etc but even with all I get a ton of mismatches ..
Any help would be most appreciated ,
best regards
frederik
Bookmarks