I have a field with this convention:
Last, First (Role)
I want it split into two fields - Name and Role - and get rid of the parentheses at the same time. Any quick way to do this? I'd like to split it based on the "space open-parentheses" rather than the "second space from the left" because of some data inconsistency. Also, the role can be more than one word so I can't use first space from the right.
I will handle splitting the name in a different operation because there are a few records with more than one comma which is screwy.
Bookmarks