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