Regular expression: Difference between revisions
Jump to navigation
Jump to search
→尋找中文、非英文的文字
| Line 367: | Line 367: | ||
=== 尋找中文、非英文的文字 === | === 尋找中文、非英文的文字 === | ||
==== 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++的搜尋 | ||
<pre> | <pre> | ||
| Line 372: | Line 373: | ||
</pre> | </pre> | ||
==== Find non-ASCII characters in LibreOffice ==== | |||
適用: [https://zh-tw.libreoffice.org/ LibreOffice] [https://help.libreoffice.org/6.2/en-US/text/scalc/01/func_regex.html REGEX] function<ref>[https://help.libreoffice.org/6.2/en-US/text/shared/01/02100001.html?&DbPAR=WRITER&System=MAC List of Regular Expressions]</ref>、Total commander 的 Multi-Rename tool<ref>取代非英文的文字，但是不包含 . 符號: <nowiki>[^\u0000-\u0080|.]+ </nowiki></ref><ref>[http://stackoverflow.com/questions/150033/regular-expression-to-match-non-english-characters javascript - Regular expression to match non-english characters? - Stack Overflow]</ref> | 適用: [https://zh-tw.libreoffice.org/ LibreOffice] [https://help.libreoffice.org/6.2/en-US/text/scalc/01/func_regex.html REGEX] function<ref>[https://help.libreoffice.org/6.2/en-US/text/shared/01/02100001.html?&DbPAR=WRITER&System=MAC List of Regular Expressions]</ref>、Total commander 的 Multi-Rename tool<ref>取代非英文的文字，但是不包含 . 符號: <nowiki>[^\u0000-\u0080|.]+ </nowiki></ref><ref>[http://stackoverflow.com/questions/150033/regular-expression-to-match-non-english-characters javascript - Regular expression to match non-english characters? - Stack Overflow]</ref> | ||
<pre> | <pre> | ||
| Line 377: | Line 379: | ||
</pre> | </pre> | ||
適用: MySQL<ref>[https://stackoverflow.com/questions/9795137/how-to-detect-rows-with-chinese-characters-in-mysql How to detect rows with chinese characters in MySQL? - Stack Overflow]</ref> | ==== Find non-ASCII characters in MySQL ==== | ||
適用: MySQL<ref>[https://stackoverflow.com/questions/9795137/how-to-detect-rows-with-chinese-characters-in-mysql How to detect rows with chinese characters in MySQL? - Stack Overflow]</ref><ref>[https://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql How can I find non-ASCII characters in MySQL? - Stack Overflow]</ref> | |||
<pre> | <pre> | ||
-- 尋找 `column_name` 欄位值包含中文字 | -- 尋找 `column_name` 欄位值包含中文字 | ||
| Line 385: | Line 388: | ||
</pre> | </pre> | ||
<pre> | |||
-- 尋找 `column_name` 欄位值不完全是 ASCII 字元 | |||
SELECT `column_name` | |||
FROM `table_name` | |||
WHERE `column_name` <> CONVERT(`column_name` USING ASCII) | |||
</pre> | |||
==== Find non-ASCII characters in PHP ==== | |||
尋找欄位值包含中文字，中文字包含繁體中文與簡體中文，不包含標點符號 (例如 {{kbd | key = <nowiki>,</nowiki>}})、全形標點符號 (例如 {{kbd | key = <nowiki>，</nowiki>}})以及特殊符號，例如 Emoji：{{kbd | key = ⭐}}。 | 尋找欄位值包含中文字，中文字包含繁體中文與簡體中文，不包含標點符號 (例如 {{kbd | key = <nowiki>,</nowiki>}})、全形標點符號 (例如 {{kbd | key = <nowiki>，</nowiki>}})以及特殊符號，例如 Emoji：{{kbd | key = ⭐}}。 | ||
PHP: exact match | PHP: exact match | ||