core.noscript.text
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?
Solved! Go to Solution.
Hi @phajiyev
You can use regex formula like below.
Workflow:
Hope this helps : )
@phajiyev ,
How about:
GetWord([Full Name], 1)
Cheers,
Mark
Thank you both!