Hello Team,
I want a regex Expression that will take only the first name in this attached text and the initial ( First letter to the second name) of the name in the text. Can you help me with this please
¡Resuelto! Ir a solución.
do you want them in the same field - if so - use something similar to @binuacs suggestion like:
regex_replace([Trainee],"^(\w+\s\w).*","$1")
Hi, @Bryth
Yes, to REGEX, but also you can do the below.
I hope that you find it helpful - Cheers!
1. Add a Formula Tool
2. First part is given by the formula GetWord(TRIM([Field]),0)
3. Second part is given by the formula LEFT(GetWord(TRIM([Field]),1),1)