6 Replies Latest reply on Aug 15, 2016 5:32 AM by Tom W

    Cleaning data fields

    An Le

      Hi,

       

      I am trying to trim data which is inconsistent. For example, I have a column for email data -

       

      RE: Book an appt

      FW: Test plan

      Transfer inquiry

      Account 12424 client

       

      I'd like to find a way to trim the text in blue. Does anyone have suggestions? Thanks