Start a new topic

First Name and Middle Initial from F M L

 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?


1 Comment

Hi Beverly,


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.


Thanks,


John

Login or Signup to post a comment