9 Replies Latest reply: Apr 29, 2014 1:15 PM by Bill Markham RSS

    Replace %Hex with character

    Bill Markham

      Hi

       

      In my source data I have a field that contains data which has %Hex characters in it, as per this example:

       

           PCI20 - %C2%BFEl agente env%C3%ADa la bolsa por la cinta antes de que se sirve la pr%C3%B3xima pax%3F

       

      What I would like to is search the string for all the % 's and for each one translate the next 2 characters to its printable character, as in replace the %3F at the end with ?

       

      Any ideas as I am flummoxed as how to approach this ?

       

       

      Best Regards,    Bill Markham