Hello all,
I'm currently having three columns in my database and trying to figure out the following.
URL: this column is editable and the user inputs a link
Root URL: this column is not editable and needs to be computed.
Extension: this column is not editable and needs to be computed.
Questions
1. How do I extract (or compute) the Root URL from a record in the URL column?
2. How do I extract (or compute) the extension from a record in the ROOT URL column?
What i've tried so far
I tried using a couple regexreplace formula's that worked in Google Sheets but Google Appsheets doesn't support this method.
Example records
1. The verge
URL: URL Removed by Staff
Expected RootURL: theverge.com
Expected Extension: .com
2. URL Removed by Staff
Expected RootURL: independent.co.uk
Expected Extension: .co.uk
3.
URL: URL Removed by Staff
Expected RootURL: duolingo.com
Expected Extension: .com
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |