Regular expression: Difference between revisions
Jump to navigation
Jump to search
m
→Find Chinese characters in Google sheet
m (→尋找英文字) |
Tags: Mobile edit Mobile web edit |
||
| Line 381: | Line 381: | ||
==== Find Chinese characters in Google sheet ==== | ==== Find Chinese characters in Google sheet ==== | ||
範例：如果 A2 | 範例：如果 A2 包含任一中文字，則欄位值顯示「中文」。如果未包含任何中文字，則欄位值顯示「英文」： | ||
<pre> | <pre> | ||
=IF(REGEXMATCH(A2, "[\一-\龥]"), "中文", "英文") | =IF(REGEXMATCH(A2, "[\一-\龥]"), "中文", "英文") | ||
</pre> | </pre> | ||
{{exclaim}} Google 不支援以下語法，會顯示「... 是無效的規則運算式。」錯誤 | |||
* {{kbd | key=<nowiki>[\u4e00-\u9fa5]</nowiki>}} | |||
* {{kbd | key=<nowiki>[\p{Script=Hans}]</nowiki>}} | |||
* {{kbd | key=<nowiki>[\p{Han}]</nowiki>}} | |||
==== Find Chinese characters in MySQL ==== | ==== Find Chinese characters in MySQL ==== | ||