Regular expression: Difference between revisions
Jump to navigation
Jump to search
m
→尋找中文、非英文的文字
m (→尋找中文、非英文的文字) |
|||
| Line 366: | Line 366: | ||
* [https://errerrors.blogspot.com/2019/03/how-to-enclose-non-empty-cell-with-double-quotes-in-google-spreadsheet.html Google 試算表的文字類型欄位值的前後加上雙引號] | * [https://errerrors.blogspot.com/2019/03/how-to-enclose-non-empty-cell-with-double-quotes-in-google-spreadsheet.html Google 試算表的文字類型欄位值的前後加上雙引號] | ||
=== 尋找中文、非英文的文字 === | === Find non-ASCII characters 尋找中文、非英文的文字 === | ||
==== Find non-ASCII characters in Google sheet ==== | ==== Find non-ASCII characters in Google sheet ==== | ||
適用: Google Drive 試算表的 Regular expression 相關函數，例如: [https://support.google.com/docs/answer/3098292?hl=zh-Hant REGEXMATCH]、[https://support.google.com/docs/answer/3098244?hl=en REGEXEXTRACT]、[https://support.google.com/docs/answer/3098245?hl=zh-Hant RegExReplace] 函數、Notepad++的搜尋 | 適用: Google Drive 試算表的 Regular expression 相關函數，例如: [https://support.google.com/docs/answer/3098292?hl=zh-Hant REGEXMATCH]、[https://support.google.com/docs/answer/3098244?hl=en REGEXEXTRACT]、[https://support.google.com/docs/answer/3098245?hl=zh-Hant RegExReplace] 函數、Notepad++的搜尋 | ||