Best way to extract URL parameters

FHLPC
New Member

I am setting up a new app to scan QR codes that have custom URL with parameters. This app is linked to google sheets.

The app is currently working, and properly scanning QR codes, and storing the info into a spreadsheet.

Now, we need to extract the URL parameters into separate columns

Here is a URL example: www.mysite.com?VAR1=one&VAR2=two&VAR3=three

Iโ€™d like to extract the 3 variables above, each one in itโ€™s own column

VAR1 | VAR2 | VAR3
one | two | three

Whatโ€™s the best formula to extract URL parameters? MID() ? FIND()?

0 4 1,053
4 REPLIES 4
Top Labels in this Space