14,953
edits
Extract url from text: Difference between revisions
Jump to navigation
Jump to search
→使用 Google sheet 擷取完整網址
mNo edit summary Tags: Mobile edit Mobile web edit |
Tags: Mobile edit Mobile web edit |
||
| Line 12: | Line 12: | ||
詳細操作說明：[https://errerrors.blogspot.com/2023/10/how-to-quickly-extract-links-from-google-sheets.html 如何從 Google 試算表，快速取出連結] | 詳細操作說明：[https://errerrors.blogspot.com/2023/10/how-to-quickly-extract-links-from-google-sheets.html 如何從 Google 試算表，快速取出連結] | ||
=== 使用 Google sheet 刪除文章內網址 === | |||
<pre> | |||
=REGEXREPLACE(A1, "(http[s]?://[a-zA-Z0-9\-_\\._~\:\/\?#\[\]@\!\$&'\(\)\*\+,;\=%]+)", "") | |||
</pre> | |||
=== 使用 Sublime Text 擷取完整網址 === | === 使用 Sublime Text 擷取完整網址 === | ||