Home
Random
Log in
Settings
About LemonWiki共筆
Disclaimers
LemonWiki共筆
Search
Regular expression: Difference between revisions
Language
Watch
View history
Edit
← Older edit
Newer edit →
Revision as of 16:25, 25 July 2023
edit
Unknown user
(
talk
)
→
Find non-ASCII characters 尋找中文、非英文的文字
← Older edit
Revision as of 16:37, 25 July 2023
edit
undo
Unknown user
(
talk
)
m
→
Find non-ASCII characters 尋找中文、非英文的文字
Newer edit →
Line 372:
Line 372:
<pre>
<pre>
[^\x00-\x80]+
[^\x00-\x80]+
</pre>
範例:如果 A2 包含任一中文字,則欄位值顯示「中文」。如果未包含任何中文字,則欄位值顯示「英文」。
<pre>
=IF(REGEXMATCH(A2, "[^\x00-\x80]+"), "中文", "英文")
</pre>
</pre>