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

    Replace %Hex with character

    Bill Markham



      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