Google Sheets REGEXEXTRACT to extract text value for URL query-parameter

Question

Given this value in A1:

https://www.rositarococo.com/?modeload=modeload-sigma-1&adsetname=cbo-LLA1apilados&adname=Default+name+-+Conversiones&placement=Facebook_Mobile_Feed

For this URL I want to extract the text cbo-LLA1apilados ("adsetname" query-parameter's value)

&adsetname=cbo-LLA1apilados&adname

My lookbehind regex doesn't work in the formula.

How to extract whats between "adsetname=" and "&adname" using REGEXEXTRACT?

player0 · Accepted Answer · 2019-12-04 18:51:11Z

1

try:

=REGEXEXTRACT(A1, "adsetname=(.+)&adname")

answered Dec 4, 2019 at 18:51

player0

131k14 gold badges91 silver badges149 bronze badges

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

1 Answer 1