Generate First and Last Name from a String field when there is delimiter/ no delimiter

[EN6924]

Hello All,

I'm learning Regex.

Trying to generate First and Last Name from a String field.

Done in 4 ways. But wanted to know if I can do this more quickly (without creating 2 formulas in a single formula tool).

Thanks.

[atcodedog05 · Accepted solution]

Hi @EN6924 

You can use a single regex for this. Makes sure case insensitive is turned off.

Hope this helps : )

[EN6924]

Thank you, you’re amazing! 😊

[atcodedog05]

Happy to help : ) @EN6924 

Cheers and have a nice day!