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



      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.