Extract url from text: Difference between revisions

Jump to navigation Jump to search
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 擷取完整網址 ===

Navigation menu