14,953
edits
Extract url from text: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with "使用正規表示法 (Regular expression) ，從文章內容中擷取網址。 == 擷取完整網址 == 使用 Google 試算表 [https://support.google.com/docs/answer/3...") |
No edit summary |
||
| Line 4: | Line 4: | ||
使用 Google 試算表 [https://support.google.com/docs/answer/3098244?hl=zh-Hant REGEXEXTRACT] 函數，從文章內容擷取第一個網址。 | 使用 Google 試算表 [https://support.google.com/docs/answer/3098244?hl=zh-Hant REGEXEXTRACT] 函數，從文章內容擷取第一個網址。 | ||
<pre> | <pre> | ||
=REGEXEXTRACT(A1, "(http[s]?://[a-zA-Z0-9\-_\\._~\:\/\?#\[\]@\!\$&'\(\)\*\+,;\=%]+) | =REGEXEXTRACT(A1, "(http[s]?://[a-zA-Z0-9\-_\\._~\:\/\?#\[\]@\!\$&'\(\)\*\+,;\=%]+)") | ||
</pre> | </pre> | ||
| Line 23: | Line 23: | ||
== 擷取網址中的網域部分 == | == 擷取網址中的網域部分 == | ||
<pre> | <pre> | ||
=REGEXEXTRACT(A1, "(http[s]?\://[^/]+) | =REGEXEXTRACT(A1, "(http[s]?\://[^/]+)") | ||
</pre> | </pre> | ||