Re: TRIM Formula
Solved
Jump to Solution
0
1543
0
1 Solution
Accepted Solutions
Hey @courtneydean!
Give this formula a shot:
IF(
AND(
{first_name},
{last_name}
),
IF(
REGEX_MATCH(
TRIM({first_name}) & TRIM({last_name}),
"[á,à,â,å,æ,ç,è,é,ë,ê,î,ï,ì,ñ,ô,ö,ò,ø,õ,ù,û,ü,ý,í,ú,ş,ó]"
),
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
REGEX_REPLACE(
TRIM(LOWER({first_name})) & "." & TRIM(LOWER({last_name})),
"ó", "o"
),
"ş", "s"
),
"ú", "u"
),
"í", "i"
),
"ý", "y"
),
"[ù,û,ü]", "u"
),
"[ô,ö,ò,ø,õ]", "o"
),
"ñ", "n"
),
"[î,ï,ì]", "i"
),
"[è,é,ë,ê]", "e"
),
"ç", "c"
),
"æ", "ae"
),
"[á,à,â,å]", "a"
),
TRIM(LOWER({first_name} & "." & {last_name}))
)
)Here's what the formula looks like in Airtable:
Hey @courtneydean!
For some reason, every time I try to post a reply with the formula body text that I wrote, the post kinda just disappears.
I've just tossed the formula I created into a gist that can be accessed here.
Here's a look at what the formula looks like in Airtable:
I'm happy to answer any questions you might have about the formula or help with any additional adjustments if you're curious.
