3 Replies Latest reply: Apr 1, 2014 12:09 PM by Herbert Chitate RSS

    Substitute Multiple Values

      Hi All,

       

      I have a field in my database that I need "cleaned out" for certain values. The data is not very good because of a lack of a validation process in when it is uploaded. I need to therefore build into my upload statement a statement that removes the following; gaps, underscore character, dash character.

       

      The field is called REG.

       

      Thank you

       

      Herbiec