Parse a Name Field with leading characters

[George_Fischetti]

Hi All,  I thought this one was pretty easy but I've having difficulty parsing a name field into First Name/Last Name when the leading characters are FBO before the first name (see below).  I've used a Regex that parses the rest of the names perfectly (^(\w+).*?(\w+)$) but have used a combination of Trim/Left/Contains and just cannot seem to get the right combination to remove the FBO.  The FBO is always in that location and shown as upper.

Name                   First Name    Last Name
Tim Jones            Tim              Jones
Mike Awesome     Mike            Awesome
Jane Doe              Jane           Doe
FBO Buddy Holly  Buddy        Holly
Snoop Dog           Snoop        Dog

Thanks!!  George

[AlexEntz · Accepted solution]

Hi George,

why not remove the FOB before using your Regex espression. I would do it like this:

Please let me know if that solves your problem.

Greetings Alex

[atcodedog05]

Hi @George_Fischetti 

Just a small updation to @AlexEntz  solution use Replace([Name], "FBO ", "") where you are removing "FBO "(followed by space)

Or use Regex like below

(\w+)\s(\w+)$

Hope this helps : )

[ChrisTX]

Here's an option that doesn't use RegEx:

Chris

[George_Fischetti]

Thank you all, while all 3 of these worked I ultimately selected the first submission as the one to use due to its simplicity.  Appreciate your guidance!!