I have not been able to deploy a working process to use multiple regex patterns to match and replace the following patterns of names. I need to extract the last name, first name, middle initial or fill it with white space, and place commas between them Examples:
In:
- "HILL,ADAM APRN"
- "SMITH,JOHN B APRN"
- "JONES-WILSON,ROBERT APRN"
Out:
- "HILL,ADAM, ,APRN"
- "SMITH,JOHN,B,APRN"
- "JONES-WILSON,ROBERT, ,APRN"
The procedure I used stopped on the first name
Any assistance would greatly be appreciated.
Thank you - Matt