1 Reply Latest reply on Oct 14, 2013 2:19 PM by Ben Neville

    replace multiple characters in string

    Harley Ellenberger

      I have a dimension called [CREATIVE].  It has values such as...

       

      GOV/VA JONES EDUCATION

      ISSUE/SIERRA TREES

      INSURANCE/UPMC HOSPITALS

       

      I want to replace both the forward slash and spaces with an underscore, so they would look like this...

       

      GOV_VA_JONES_EDUCATION

      ISSUE_SIERRA_TREES

      INSURANCE_UPMC_HOSPITALS

       

      What's the syntax of the calculated field to accomplish this?