BigQuery regex remove/replace a list of text from a string

Question

How would I go about removing a list of text within a string? Essentially have a URL column and want to avoid grossly long regexp's and multiple nested replace functions.

Is there a way to declare a list of text such as "http", "www.", etc and have them removed from the column in one go?

Please provide sample data and desired results.

Gordon Linoff
– Gordon Linoff

2021-03-12 02:31:47 +00:00
Commented Mar 12, 2021 at 2:31 — Gordon Linoff
– Gordon Linoff, Commented Mar 12, 2021 at 2:31

Mikhail Berlyant · Accepted Answer · 2021-03-12 04:27:35Z

6

You can use below simple approach

with t as (
  select 'Is there a way to declare a list of text such as "http", "www.", etc and have them removed from the column in one go?' col
)
select regexp_replace(col, r'http|www.|etc', '') cleaned_col
from t

with output

answered Mar 12, 2021 at 4:27

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

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

Collectives™ on Stack Overflow

BigQuery regex remove/replace a list of text from a string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related