Fixing ingested urls, removing %2f etc

I want to convert these url parts to proper url strings to pull reports from, they are generated by a url themselves.     Theres a couple of urls chained here until i get to a CSV at thi...