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()?