3 Replies Latest reply on Sep 17, 2018 3:14 PM by Peter Fakan

    Trim a space after a coma

    Luis Amadeo

      I have a field called Name. This are the names of individuals. However, due to data entry errors, some names have a space after a coma separating last and first name.

       

      Doe, Jane

      Doe,Jane

      Nader,Ralph

      Johnson, Tom

      Johnson,Tom

       

      Doe, Jane and Doe,Jane are the same person. How do I trim the extra space before the first name or if it is easier, how to add a space after the coma. I have tried using the find and Rtrim commands but I am missing something.

       

      Thanks.