I should start out saying that RegEx patterns is not my area of expertise. With that said I am trying to get First Name from the following pattern
Last Name, First Name example: Doe, John
I want to store "John" in result1.
Here is the pattern I have come up with that doesn't appear to return th desired results.
I used a tool from gskinner.com to formulate the pattern and I believe it returns what I am looking for however when I use this pattern in SPD with the Capture Text Action, it returns ' '.