Extract UTM parameters in Google Sheets

Question

I need to extract UTM parameters in Google Sheets and I have, I believe, a simple question.

I would like to extract the value associated to the utm_campaign in column A to column B:

If possible, I would like to keep the opportunity to do an Arrayformula for all the lines in column A and avoid using a script to do so.

score 1 · Answer 1 · edited Nov 04 '19 at 11:16

1

Okay, so I found an answer by myself!
Using the formula below works in that case:

=arrayformula(if(A2:A="","",REGEXEXTRACT(A2:A, "utm_campaign"":""([^""]+)""")))

edited Nov 04 '19 at 11:16

player0

answered Nov 04 '19 at 11:01

Hugo

score 1 · Accepted Answer · answered Nov 04 '19 at 11:01

1

try:

=ARRAYFORMULA(IFNA(REGEXEXTRACT(A2:A, "utm_campaign"":""(\d+)")))

answered Nov 04 '19 at 11:01

player0

2 Answers2