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
Solved! Go to Solution.
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)