Welcome to the community, @Deelemma! :grinning_face_with_big_eyes: This can be done using the following formula:
IF({Email Address}, SUBSTITUTE(REGEX_EXTRACT(emails, "[^@]+"), ".", " "))
This extracts all characters up to—but not including—the @ symbol, and then replaces the period in the extracted text with a space.
If you want to capitalize the first letter of each extracted name element, here’s a longer version that will do that:
IF(Email, UPPER(LEFT(Email, 1)) & REGEX_EXTRACT(Email, "(?:.)((^\\.]*)") & " " & UPPER(MID(Email, FIND(".", Email) + 1, 1)) & REGEX_EXTRACT(Email, "(?:,^\\.]*..)(]^@]*)"))
You can use a formula field to extract the parts of the email address. However, note that that would not appear in the form itself. The formula field would be a different field from the field in the form used to enter the name.
There are many different possible formula fields. Here is one that uses regular expressions.
REGEX_REPLACE(Email, "(\\w+)\\.(\\w+)@.+", "$1 $2")
Welcome to the community, @Deelemma! :grinning_face_with_big_eyes: This can be done using the following formula:
IF({Email Address}, SUBSTITUTE(REGEX_EXTRACT(emails, "[^@]+"), ".", " "))
This extracts all characters up to—but not including—the @ symbol, and then replaces the period in the extracted text with a space.
If you want to capitalize the first letter of each extracted name element, here’s a longer version that will do that:
IF(Email, UPPER(LEFT(Email, 1)) & REGEX_EXTRACT(Email, "(?:.)((^\\.]*)") & " " & UPPER(MID(Email, FIND(".", Email) + 1, 1)) & REGEX_EXTRACT(Email, "(?:,^\\.]*..)(]^@]*)"))
OMG with the caps were a nice touch! Thank you all. This puppy is SOLVED!
