Extract Title from string

[ramanm43]

Hi All,

Hope someone is able to assist.

I have a list of names from which I need to separate the title, first name and surname. Some of these records do not contain a title which makes things a lot more difficult.

Below is an example of the data:

Name

MR P J Morrisey

MR Tom McCarthy

MRS Mary Monks

Jack O'Driscoll

MR Tom Dunne

MS Anne-Marie Rath

MR Eric  Scott

Michael Healy

MR Kieran McGovern

Appreciate any help.

Thanks

[atcodedog05]

Hi @ramanm43 

Here is how you can do it.

Workflow:

Edit: updated with few fixes

Hope this helps : )

[HomesickSurfer]

Hi @atcodedog05 

Love it!

@ramanm43 , perhaps consider modification to the expression to additionally include the following as either start or end to name strings, w or w/o the periods.

Dr. (Doctor)
Esq. (Esquire)
Hon. (Honorable)
Jr. (Junior)
Msgr. (Monsignor)
Prof. (Professor)
Rev. (Reverend)
Rt. Hon. (Right Honorable)
Sr. (Senior)
St. (Saint)

[atcodedog05]

Hi @ramanm43 

Thats true as @HomesickSurfer said you might have to identify all titles first 😅.  Hopefully its only Mr, Ms, Mrs 🙂