Hello everyone,
I’m trying to separate firstname and lastname using formulas I found online.
My issue is that some french name are like: John De Doe
The first word is always the firstname, the rest is the lastname.
I have this formula for firstname:
IF({Nom complet}, REGEX_EXTRACT({Nom complet}, ".* "))
And I have this formula for lastname:
IF({Nom complet}, REGEX_EXTRACT({Nom complet}, "\\s(.*)"))
It outputs “John De” as firstname instead of “John”.
and “De Doe” as lastname which is what I want.
I need a formula to get first word (preferably using regex) that works with special characters.
Thank you for your help,
Joachim
