Selecting Middle Name with Formula tool

[phajiyev]

Hi, I have a column which have names in full format (e.g. Robert Downey Junior), and I want to extract the middle name (Downey) with formula tool, any suggestions?

[atcodedog05 · Accepted solution]

Hi @phajiyev 

You can use regex formula like below.

Workflow:

Hope this helps : )

[MarqueeCrew · Accepted solution]

@phajiyev ,

How about:

GetWord([Full Name], 1)

Cheers,

Mark

[phajiyev]

Thank you both!