8 Replies Latest reply: Oct 29, 2015 9:05 AM by Louise Grauss-Spoormaker RSS

    Rename text within a field

    Louise Grauss-Spoormaker

      Hi,

       

      Is it possible to search for parts of text and rename them.

      For example, my description now looks like this:


      ItemDescription
      ASoft Blue Adrien
      BAdrien Light Tan
      CAdrien White/Blue eclipse Nappa/Pu/Nappa
      DWhite/Nautical Blue Adrien Nappa/Pu/Patent
      EJester - Suede/burning lthr - Logger XS
      FLogger XS Dutch blue
      GLogger XS- Dutch blue - Suede/burning lthr/suede perf
      HIce Blue Logger XS Suede canvas

       

      I want the fields where 'Adrien' is mentioned in the description, to be renamed to 'Adrien'.

      And when 'Logger XS is mentioned I want them to be renamed to 'Logger XS'.

       

      ItemDescriptionNew Description
      ASoft Blue AdrienAdrien
      BAdrien Light TanAdrien
      CAdrien White/Blue eclipse Nappa/Pu/NappaAdrien
      DWhite/Nautical Blue Adrien Nappa/Pu/PatentAdrien
      EJester - Suede/burning lthr - Logger XSLogger XS
      FLogger XS Dutch blue Logger XS
      GLogger XS- Dutch blue - Suede/burning lthr/suede perfLogger XS
      HIce Blue Logger XS Suede canvas

      Logger XS

       

      Is this possible?

       

      I tried a formula like this:

       

      aggr(if(left("[Description]",2)='Adrien', 'Logger XS', ''), "[Description]")

       

      But that is not working, I think because the search criterea can be everywhere in the description?