Hi,
I'm working on a project where I'm trying to pull data from the table at https://thestreamable.com/markets/tampa-st-petersburg-sarasota-fl
The table shows what local tv stations are available in Tampa for each OTT provider.
I've pulled tables before from websites using Text Input > Download > Text to Column > Multi-Row Formula but I can't seem to figure out this one.
Inspecting the page in Chrome I can see in the Elements where the table is and the different tags and elements but I'm not sure how to bring in the data. If you hover over the green dot it actually shows the call letters of the station too.
Thanks for any help on this.
Solved! Go to Solution.
Hi @BonusCup,
The tables on this page have a couple of things to consider:
So, the start is the same as I would always do, look for <table(.*?)</table> and then the <tr> tags for rows
But then it gets more interesting with the Rowspan and Colspan. After idetifying the multiple column/row pieces, a mixture of multi-row and generate rows (as well as a cheeky trick to make sure the new line appears before the others) will get the order correct.
After that it's just cleanup.
I've attached the workflow that these screenshots came from. Some of the column naming might be odd, but that's because I stole parts from a Table Parser Macro that I have (as it didn't deal with the rowspan etc properly)
Hi @BonusCup ,
I'm not sure how much data you're looking to pull from the website but I hope this can help with the start.
Cheers,
Ganesh
Thanks so much for this! It got me to exactly what I needed. With a little bit of tweaking, I added an extra piece at the beginning of yours that finds all the URLs for all the markets from https://thestreamable.com/markets and then that flows into your example.
Thanks again!
Thank you for the details for each area. It was very informative. I was able to use Brandon's but I'm going to dig into your workflow to look at alternatives for a better understanding.
Thanks