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

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