7 Replies Latest reply: Oct 22, 2012 3:48 PM by Celambarasan Adhimulam RSS

    Replace more than one Value

      I have the following column:

      Medium:

      cpc

      cpc

      none

      none

      none

      organic

      email

       

      I would like to do the following replacements within Medium field:  cpc --> PPC

                                                                                                   none --> Direct

                                                                                               organic --> SEO

                                                                                                  email --> Campaign

       

      what function would be the best to use and how would the script look like?

       

      Thanks,