V
V
Vladimir Kalaganov2019-03-21 17:51:12
Google Sheets
Vladimir Kalaganov, 2019-03-21 17:51:12

How to extract from a string the text that is between certain text?

Good afternoon, friends, can you tell me how to extract from the text:
domen .ru/?utm_source=yandex&utm_medium=cpc&utm_campaign=nazvanie_campanii&utm_content=name-ads&utm_term=kluck
The content of the utm tag is nazvanie_campanii It is
necessary to automatically extract what is between "utm_campaign=" and "&utm_content= "
For example:
5c93a48a1c05f425803737.png
Link to spreadsheet from screenshot: https://docs.google.com/spreadsheets/d/1qrsv4dxkiz...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-03-21
@Kalaganov5

=MID(B2;FIND("campaign=";B2)+9;FIND("&utm_content";B2)-FIND("campaign=";B2)-9)
Registered in the file by reference

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question