14,953
edits
Extract domain from text: Difference between revisions
Jump to navigation
Jump to search
m
→Using Google Sheets to extract domains
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| 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> | ||
Input: | Input text: | ||
<pre> | <pre> | ||
Yahoo! News https://tw.news.yahoo.com/abc | Yahoo! News https://tw.news.yahoo.com/abc | ||