14,953
edits
Extract domain from text: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with "Extract the domain part from URLs in article content == Using Google Sheets to extract domains == Use Google Spreadsheet [https://support.google.com/docs/answer/3098244?hl=en REGEXEXTRACT] function <pre> =REGEXEXTRACT(A1, "(http[s]?\://[^/]+)") </pre> Input: <pre> Yahoo! News https://tw.news.yahoo.com/abc </pre> Output: <pre> https://tw.news.yahoo.com </pre> Explanation: * Domain refers to text that starts with <nowiki>http://</nowiki> or <nowiki>https://</nowiki>, f...") |
No edit summary |
||
| Line 1: | Line 1: | ||
Extract the domain part from URLs in article content | Extract the domain part from URLs in article content | ||
{{LanguageSwitcher | content = [[Extract domain from text | English]], [[Extract domain from text in Mandarin | 漢字]] }} | |||
== Using Google Sheets to extract domains == | == Using Google Sheets to extract domains == | ||