We need to create a dictionary that will combine the Middle Name or Initial with the first name. The value in the field is First Name Middle Initial Last Name. Not all names have a middle initial. Some are simply "John Doe" and some are "Jane C. Doe"
We want Jane C. to be in the First Name Field.
Can anyone help?
This should do the trick for you.
First line value to match on (.+) (.+) replacement value $1
Second line value to match on (.+) (.+) (.+) replacement value $1 $2
RegEx turned on on both lines.