使用 REGEXMATCH for Google Sheets 检查非拉丁字符 [英] Check for non-latin characters with REGEXMATCH for Google Sheets
本文介绍了使用 REGEXMATCH for Google Sheets 检查非拉丁字符的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我试图制作一个公式，它只需要返回 TRUE |如果单元格包含一个或多个非拉丁字符并尝试过类似的操作，但失败了，则为 FALSE - 它始终为 TRUE (
或 TRUE/FALSE 恢复:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A2, "[^A-Za-z@.]"))<>"")I tried to make a formula which just have to return TRUE | FALSE if a cell contains one or more non-latin characters and tried something like this, but failed - it's always TRUE (found nothing here):
=REGEXMATCH(B2; "[[:^alpha:]]+")
Some examples of data:
- daocao@yahoo.com - there are no non-latin characters
- huynhbaoquóqdq@gmail.com - there is a non-latin character
What is wrong with it?
解决方案
try:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A2, "[^A-Za-z@.]"))="")
or TRUE/FALSE reverted:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A2, "[^A-Za-z@.]"))<>"")
这篇关于使用 REGEXMATCH for Google Sheets 检查非拉丁字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
