Web Scraping using regex and parsing tools

[Sarav_93]

Hi Everyone!

I am trying to extract the table from website with Alteryx. Can anyone help to extract the table using regex expression.

https://www.bankofengland.co.uk/boeapps/database/Rates.asp?into=USD&rateview=D

[bgreedy]

The regex "<table\swidth.*?</table" extracts just the table we want, and the regex "<tr.*?</tr" extracts the data for each row.

The workflow attached takes you some of the way there, however the data will need further cleansing and formatting.

[RaphaelSilva · Accepted solution]

I came across a similar solution, extracted in different rows and cleaned using Regex.
Split between values and headers, so you can have it reflected correctly even if you download another set of data in the future.

 
##
Please like and/or favorite the reply if you found it valuable, it supports the community 

[Sarav_93]

Thank you so much.