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
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
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.
Thank you so much.
