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()?
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |