Extract domain from text - Revision history

Planetoid: /* Using Google Sheets to extract domains */

2025-12-24T06:50:46Z

Using Google Sheets to extract domains

← Older revision		Revision as of 14:50, 24 December 2025
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(A1, "(http[s]?\://[^/]+)")		=REGEXEXTRACT(A2, "(http[s]?\://[^/]+)")
	</pre>		</pre>

Planetoid: /* Using Google Sheets to extract domains */

2025-05-12T08:15:32Z

Using Google Sheets to extract domains

← Older revision		Revision as of 16:15, 12 May 2025
Line 9:		Line 9:
	</pre>		</pre>

	Input:		Input text:
	<pre>		<pre>
	Yahoo! News https://tw.news.yahoo.com/abc		Yahoo! News https://tw.news.yahoo.com/abc

Planetoid at 07:21, 28 March 2025

2025-03-28T07:21:25Z

@@ Line 21: / Line 21: @@
 Explanation:
 * Domain refers to text that starts with <nowiki>http://</nowiki> or <nowiki>https://</nowiki>, followed by multiple characters that are not the symbol {{kbd | key = <nowiki>/</nowiki>}}: {{kbd | key = <nowiki>[^/]+</nowiki>}}. =
 [[Category: Regular expression]] [[Category: Data Science]] [[Category: String manipulation]]

Planetoid at 07:19, 28 March 2025

2025-03-28T07:19:20Z

← Older revision		Revision as of 15:19, 28 March 2025
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 ==

Planetoid: 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

 =REGEXEXTRACT(A1, "(http[s]?\://[^/]+)")

Input:

 Yahoo! News https://tw.news.yahoo.com/abc

Output:

 https://tw.news.yahoo.com

Explanation: * Domain refers to text that starts with http:// or https://, f..."

2025-03-28T07:18:10Z

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..."

New page

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>, followed by multiple characters that are not the symbol {{kbd | key = <nowiki>/</nowiki>}}: {{kbd | key = <nowiki>[^/]+</nowiki>}}. =

[[Category: Regular expression]] [[Category: Data Science]] [[Category: String manipulation]]