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,
Your "Blank" replacement value does not look correct. To add that value, you leave the value blank, and click the + button--the systems adds the blank value. If you're getting "blank" in your output, that has been added as text. In the attached screen shot, you'll see that my "blank" value looks different.
You can copy and paste the dictionaries that I included earlier (start with a completely new dictionary):
So far so good :)
Thanks very much.