nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Simple regex query - extract url of csv file from html of webpage

jt_edin

I know this is trivial to a regex pro, but to me it's daunting because I still struggle with regex! I know, I know. But if it's useful to me it's going to be useful to someone else too, hence this post. Kudos up for grabs!

This is my url: https://edinburghcyclehire.com/open-data/historical

I want to extract any hyperlink to a csv file to new rows. I want to discard all other data. The pattern starts with href=" and then the pattern stops after .csv

I could do this with text to columns but regex would be nicer. I note that the url appears twice (once in the href= tag, and once with the content= tag. I just need each url once.

Please can someone show me how to do this quickly and elegantly in regex? I have attached the url and download tool to save time. Thanks

07 Parse csv from url.yxmd

Regex

Parse

Download

Accepted answers

Dazzerman

Sure, no problem.

07 Parse csv from url_solution.yxmd

All comments

Dazzerman

Hi @jt_edin ,

I just tried this Regex quickly, which pulled out several of the CSV paths.

href="([^"]*?csv)

Will fire my laptop up with Alteryx on to provide a fuller workflow, unless someone beats me to it! 🙂

LukeG

Hi @jt_edin

I put @Dazzerman solution into a workflow for you.

Using the regex tool and the expression from @Dazzerman comment on the DownloadData field, you can parse each url into an individual row.

Be sure to use the Tokenize method and Split to Rows in the regex tool as well.

Let me know if there are any questions!

- Luke

DazzermansSolution.yxmd

Dazzerman

Thanks @LukeG !

Thanks for posting!

I got my machine and solution up and running just a few minutes after your post, and the only difference with my solution was that I added a Select to just pull out the tokenised field. Oh, and I added one more double-quote after the closing bracket that may not be necessary, but may be belt and braces in case the 'csv' text appeared in the URL. That's not the case at the moment, but you never know!

Hope this helps @jt_edin

jt_edin

Wonderful. Thank you @LukeG and @Dazzerman

But what does it mean? Why do we need all the ([^"]*? symbols between our start and end strings? Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15898

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703