regex101: Golang Match Workspace

Pro

/product/the literal text /product/ (case sensitive)

Non-Capturing Group(?:[^/]+/)*

*repeats the group contents below any number of times:

Negated Character Class[^/]+

+matches at least one character outside the set below:

/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group 1([^/]+)

Negated Character Class[^/]+

+matches at least one character outside the set below:

/the literal / (47₁₀ / 57₈ / 2F₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Character Class[0-9]+

+matches at least one character from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

25 tokens

Regular Expression

/product/(?:[^/]+/)*([^/]+)-[0-9]+$

New

i am trying to extract the product names from the URLs below using regex in Google BigQuery:

https://www.example.com/en/uk/product/clothing/trousers-leggings/cool-grey-joggers-9800977

Product name should be: cool-grey-joggers

https://www.example.com/en/uk/product/hot-denim-dress-7842666

Substitution

i am trying to extract the product names from the URLs below using regex in Google BigQuery:

https://www.example.com/en/uk/product/clothing/trousers-leggings/cool-grey-joggers-9800977

Product name should be: cool-grey-joggers

https://www.example.com/en/uk/product/hot-denim-dress-7842666