We have a field that includes 'last name, first name'. I want to separate the last and first names using regex.
I can separate the last name from the first name however the comma stays with the last name. I need to drop the comma.
Any thoughts on what expression to use?
Thanks very much,
Joshua, can you share your current regex string? Thanks, Dennis firstname.lastname@example.org