Regex Expression

[Bryth]

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

[binuacs · Accepted solution]

@Bryth Something like below?

[flying008 · Accepted solution]

Hi, @Bryth 

Maybe like this is your want ?

[apathetichell]

do you want them in the same field - if so - use something similar to @binuacs suggestion like:

regex_replace([Trainee],"^(\w+\s\w).*","$1") 

[RobertOdera]

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)