KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Is there an easy way to do URL decoding within the BigQuery query language? I'm working with a table that has a column containing URL-encoded strings in some values. For example: http://xyz.com/example.php?url=http%3A%2F%2Fwww.example.com%2Fhello%3Fv%3D12345&foo=bar&abc=xyz I extract the "url" parameter like so: SELECT REGEXP_EXTRACT(column_name, "url=([^&]+)") as url from [mydataset.mytable] which gives me: http%3A%2F%2Fwww.example.com%2Fhello%3Fv%3D12345 What I would like to do is something like: SELECT URL_DECODE(REGEXP_EXTRACT(column_name, "url=([^&]+)")) as url from [mydataset.mytable] thereby returning: http://www.example.com/hello?v=12345 I would like to avoid using multiple REGEXP_REPLACE() statements (replacing %20, %3A, etc...) if possible. Ideas?
Tags (comma-separated)
Save Edits
Cancel