Replace String from the End of an String | REGEXP_REPLACE()

Question

I am looking (probably) for REGEXP_REPLACE() in BigQuery to remove specific strings from the end of another string.

I need to remove ".html" and ".htm" and "/" (...plus a few more strings) from the end of the following URLs:

someurl.com/page.html
someurl.com/page.htm
someurl.com/page/
someurl.com/page/

I know I need REGEXP_REPLACE() but I'm too lame to build it.

Can someone give me a little push?

Thx!

DZ

Mikhail Berlyant · Accepted Answer · 2021-02-09 20:23:36Z

2

Use below

select 
  url, 
  regexp_replace(url, r'(.html|.htm|/)$', '') output
from t

If applied to sample data in your question - output is

answered Feb 9, 2021 at 20:23

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1