5 Replies Latest reply: Sep 16, 2017 3:06 AM by Antonio Mancini RSS

    Cleansing the input data

    RAM MUTHIAH M

      I have input data like this. Need output like below

       

      Input

      Output

      BlaBla-OM-17238812

      OM-17238812

      BlaBla-(@hgjhg)-DR-OM-17230000

      OM-17230000

      MID-BBM-OM-16210030

      OM-16210030

      (@hgjhg)OM-FR15AR0101

      OM-FR15AR0101

      BlaBlaBla-OM-DR-10000

      OM-DR-10000

      OM-GPC-1235-4 postn

      OM-GPC-1235