3 Replies Latest reply: May 17, 2015 2:50 PM by Massimo Grossi RSS

    Find and Replace Multiple Characters

      I have a field where I want to find and replace a multiple letters within the data of a field.  See example below.

       

      11111A

      11111B

      11111C

       

      I need to replace A, B and C.  A should be replaced with 1, B with 2 and C with 3 when present.  I know if I just had one character, I could just use the REPLACE function.  But in this case I have multiple different characters that could be found within the field.  How do I go about search and replacing multiple characters with the data of a field. Hopefully, that makes sense.

       

      Thank you in advanced for your assistance.

       

      Brian