Hi ReEx experts!
I am trying to match the name and nickname of a person whose records are provided in this format:
Lastname, Firstname (nickname) (ID)
Doe, Robert (Bob) (1234)
Nickname is optional so it could be there, or not.
I want to extract just the part of the name that precedes the ID, including the nickname if it's there. Ex:
Doe, Robert (Bob) . A name without a nickname should also be captured.
This is the closest I could get to it, but I'm still missing the trailing parenthesis for the nickname:
Any idea about what I need to add to capture the full name/nickname? Thanks!