2 Replies Latest reply on Jun 15, 2016 12:32 PM by Beth Whitney

    Split data using multiple separators

    Beth Whitney

      I am trying to remove specific separators from a string of data.  Specifically, removing dashes and blank spaces from the middle of a string.  Here is a small sample of the data and the result I am trying to achieve.

       

      Current
        Field Values
      Required Field Values
      ABARCA SOTOABARCASOTORemove space
      ABBDUROABBDUROkeep
      ABBOTT RICHARDSABBOTTRICHARDSRemove space
      ABDALLAABDALLAkeep
      ABDIKAEIRABDIKAEIRkeep
      ABU AL RUBABUALRUBRemove 2 spaces
      ABU-DAYEHABUDAYEHRemove dash
      ACEVESACEVESkeep
      ACOSTA MENJIVARACOSTAMENJIVARRemove space
      ADAMADAMkeep
      AL CANTAR-ESTRADAALCANTARESTRADARemove space & dash