14,953
edits
Extract domain from text: Difference between revisions
Jump to navigation
Jump to search
m
→Using Google Sheets to extract domains
| Line 6: | Line 6: | ||
Use Google Spreadsheet [https://support.google.com/docs/answer/3098244?hl=en REGEXEXTRACT] function | Use Google Spreadsheet [https://support.google.com/docs/answer/3098244?hl=en REGEXEXTRACT] function | ||
<pre> | <pre> | ||
=REGEXEXTRACT( | =REGEXEXTRACT(A2, "(http[s]?\://[^/]+)") | ||
</pre> | </pre> | ||