Remove Prefix from Data values

[Preeti2]

I want to design a simple workflow  with Legal name and ID where in I want to remove prefix from legal names. So for example, "Mr. Joan Thomas"  should show up as "Joan Thomas" under legal name in my workflow. Can you suggest a method?

[JosephSerpis · Accepted solution]

Hi @Preeti2 I mocked up a workflow let me know what you think?

[Preeti2]

Thank you! This is great!

[Nazia]

@JosephSerpis 

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  REGEX Replace formula 

REGEX_Replace([Provider Name], '(^DVM)|(DVM$)|(^VMD)|(VMD$)|(^CVA)|(CVA$)|(^CCRT)|(CCRT$)|(^CHTV)|(CHTV$)|(^DVM,CVA,CCRT,CHTV)|
(^DACVECC)|(DACVECC$)|(DVM,CVA,CCRT,CHTV$)', '')

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

Reply

0 LIKES

Share