Web Scraping -- Country and Country Code

smoskowitz

Hello --

I am trying to scrap some country/country code information from the following site: https://www.irs.gov/e-file-providers/foreign-country-code-listing-for-modernized-e-file

I can get the country using the regex tool, but can't seem to figure out how to get the next piece. Below is what I am trying to get:

Here is what I have done so far:

I have no regex skills so this is just Googling around. Let me know what I am missing. I should have about 258 rows of data.

Thanks,

Seth

Kenda

Hey @smoskowitz! I created a small workflow that may be able to help you out. I first split the DownloadData field into rows based on new lines. I used a Formula tool to parse out the parts of the field we wanted to keep. Then a Multi-Row Formula tool and and a Filter tool to get the country code next to the corresponding country. Hope this helps!

scrape countries.yxmd