15,039
edits
Regular expression: Difference between revisions
Jump to navigation
Jump to search
→Find Non-ASCII Characters (Chinese/Non-English Text)
| Line 187: | Line 187: | ||
=== Find Non-ASCII Characters (Chinese/Non-English Text) === | === Find Non-ASCII Characters (Chinese/Non-English Text) === | ||
==== In LibreOffice ==== | ==== In LibreOffice ==== | ||
<pre>[^\u0000-\u0080]+</pre> | <pre>[^\u0000-\u0080]+</pre> | ||
==== Find Chinese Characters in Google Sheets ==== | ==== Find Chinese Characters in Google Sheets ==== | ||
| Line 201: | Line 198: | ||
<pre>=IF(REGEXMATCH(A2, "[\一-\龥]"), "Chinese", "English")</pre> | <pre>=IF(REGEXMATCH(A2, "[\一-\龥]"), "Chinese", "English")</pre> | ||
==== Find Non-ASCII Characters in Google Sheets ==== | ==== Find Non-ASCII Characters in Google Sheets ==== | ||
| Line 243: | Line 239: | ||
FROM `table_name` | FROM `table_name` | ||
WHERE `column_name` <> CONVERT(`column_name` USING ASCII)</syntaxhighlight> | WHERE `column_name` <> CONVERT(`column_name` USING ASCII)</syntaxhighlight> | ||
==== Find Chinese Characters in PHP ==== | ==== Find Chinese Characters in PHP ==== | ||
| Line 274: | Line 270: | ||
preg_match_all($pattern, $string, $matches, PREG_OFFSET_CAPTURE); | preg_match_all($pattern, $string, $matches, PREG_OFFSET_CAPTURE); | ||
var_dump($matches);</syntaxhighlight> | var_dump($matches);</syntaxhighlight> | ||
=== Find ASCII Characters in PHP === | === Find ASCII Characters in PHP === | ||