Help me in removing Suffix from Names

Hi Team,

I want to remove suffix such as Mr. Mrs. Miss Ms. Dr. from names which generally comes in the last with or without space. Please help me removing from last only but sometimes we have names ending with Mr. or Mr. like ADAMS or MYANMR. how to solve this. I have a list where I have put some suffix in the beginning as well but I want them to be the same without any change. Kindly refer names for example below:

(Example removed)

Parse

Join

Accepted answers

carlosteixeira

Hello @mmustkee

folow a workflow with one way to do this.

I hope help!

carlosteixeira

Hello @mmustkee

Try use this.

I used a REGEX formula

REGEX_Replace([Field1], '(^MRS)|(MRS$)|(^MS)|(MS$)|(^MR)|(MR$)|(^DR)|(DR$)|(^MSMRS)|(MSMRS$)|(^MISS)|(MISS$)', '')

(^MRS) - Star with MRS

| - OR

(MRS$) - Finish with MRS

and successively.

I hope this help

Suffix from Names_V1.yxmd

mmustkee

Great help.

Thanks a lot.

All comments

carlosteixeira

Hello @mmustkee

folow a workflow with one way to do this.

I hope help!

mmustkee

Thanks a lot Carlos.

It worked.

Nazia

carlosteixeira Hello, Can I use the same formula for removing prefix like Mr /Mrs / Dr / Miss from field names?

carlosteixeira

Hi @Nazia yes, absolutely.

Nazia

carlosteixeira

Thanks a lot for replying! I have a column called Provider Name from which I want to remove Prefix like Mr. / Dr. / Miss / Mrs. and Suffix like DVM /MVD etc

i was able to remove suffixes using your REGEX Replace formula

However not able to remove prefixes using the same.

Attaching the column Provider Name from which I wish to remove Prefix and Suffix before and after I used your formula

Provider Name

Cristina Portus , DVM
Dr. Eugenie Bucher, VMD
Dr. Marco Ruffato, DVM
Dr. Eugenie Bucher, VMD
Dr. Eugenie Bucher, VMD
Dr. Eugenie Bucher, VMD
Dr. Eugenie Bucher, VMD
Dr. Eugenie Bucher, VMD
Dr. Eugenie Bucher, VMD
Dr. Eugenie Bucher, VMD
Paula E Gore Miller

Cindy Krane, DVM
Cindy Krane, DVM
Cindy Krane, DVM
Dr. Glenn M Zeitz, VMD
Dr. Glenn M Zeitz, VMD
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Anna C Aristide
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. Anthony Krawitz, DVM
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. A. Turkell, DVM,CVA,CCRT,CHTV
Dr. Glenn M Zeitz, VMD
Dr. Glenn M Zeitz, VMD

carlosteixeira

Hi @Nazia

Please try to use this workflow.

Thanks

Suffix from Names_V2.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335