Jun 14, 2024 07:24 AM
Hello,
I am working on a base that includes artists' names and a lot of them have diacritics in their first and last name. Is there a formula that I can use that could identify if there are diacritics used? It can be a simple True or False formula that I can then use a filter to isolate everyone with diacritics in their name.
For First and Last name I am used simple Single line columns.
A list of names is important because it is used for a remapping feature on our website, so the end result for airtable needs to be a filtered view of names. I appreciate any help you can provide with this.
Solved! Go to Solution.
Jun 15, 2024 02:48 AM
Hmm diacritics as in stuff like "á"? If so, perhaps you could try:
IF(
ISERROR(REGEX_EXTRACT(Name, '[^\\x00-\\x7F]')),
"No ",
"Yes"
)
My regex isn't that great though so hopefully someone else might have a better solution!
Jun 15, 2024 02:48 AM
Hmm diacritics as in stuff like "á"? If so, perhaps you could try:
IF(
ISERROR(REGEX_EXTRACT(Name, '[^\\x00-\\x7F]')),
"No ",
"Yes"
)
My regex isn't that great though so hopefully someone else might have a better solution!
Jun 15, 2024 07:32 AM
@TheTimeSavingCo 's answer works nicely for the full range of ascii characters. Not that it matters necessarily but I would have used a straight REGEX_MATCH which returns true if a diacritic is found in the provided string {Artist} and false if not.
REGEX_MATCH({Artist}, '[^\\x00-\\x7f]')