3 Replies Latest reply on Apr 8, 2016 12:08 PM by GeofferyH

    GREP Swap Lastname(s), Firstname(s)

    GeofferyH Level 1

      I have a list of names that I can use a simple GREP to swap Lastname, Firstname — however, I have names like:

      Smith, John David

      Smith Davis, John

      Smith-Davis, John

      Smith, John D'angelo

      and so on.

       

      So the Lastname is 1 to 4+ names (Lastnames are all followed by a Comma) and the Firstname is 1 to 4+ names.

       

      I've played with this for a while with no luck. Any help with this would be appreciated.