First day of dashboard week. I created an iterative macro to scrape data from the Asos website to visualise in Tableau.
The two most useful pieces of RegEx I used were:
The non greedy expression .*? to get clumps of data between fields: for example <article.*?
Using [a-z’-]* instead of \w* so that i could capture any number of words separated by hyphens.
It worked out perfectly in the end, but took waayyyyy longer than expected, so while it was an exciting day of Alteryx, the dashboard…