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?
Hi @Preeti2 I mocked up a workflow let me know what you think?
Thank you! This is great!
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 , DVMDr. Eugenie Bucher, VMDDr. Marco Ruffato, DVMDr. Eugenie Bucher, VMDDr. Eugenie Bucher, VMDDr. Eugenie Bucher, VMDDr. Eugenie Bucher, VMDDr. Eugenie Bucher, VMDDr. Eugenie Bucher, VMDDr. Eugenie Bucher, VMDPaula E Gore Miller
Cindy Krane, DVMCindy Krane, DVMCindy Krane, DVMDr. Glenn M Zeitz, VMDDr. Glenn M Zeitz, VMDDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVAnna C AristideDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. Anthony Krawitz, DVMDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. A. Turkell, DVM,CVA,CCRT,CHTVDr. Glenn M Zeitz, VMDDr. Glenn M Zeitz, VMD
