6 Replies Latest reply: Nov 30, 2016 3:22 AM by Sunny Talwar RSS

    PurgeChar or Replace

    Hasvine Dhurmea

      Hello All,

       

      I have a field as per below:

       

         

      NameTelUnwanted Character
      A#65#2310#65#
      B02629235060
      C60008@172.30.33.75:5060@172.30.33.75:5060
      D#55#0262484535#55#0
      E262692615186262
      F(02)62722366(02)

       

       

       

       

      I need to clean that 'Tel' field  and kind of standardise it.

       

      Any idea on how I can do this? (Like exclude my unwanted  characters and make the number like 10 or 12 numbers)

       

      Many Thanks,

       

      Hasvine