3 Replies Latest reply on Aug 7, 2017 3:30 PM by Yandy Plasencia

    Alias Name

    Nandhakumar Ramanathan

      Hi All,

       

      I want to call a name 'Nominate' if my fourth character is 'N' and 'Invest' if character is 'I' like this if it is 'B' then it should be 'Batch'

       

       

      for eg., A2ANAI70 this has to be rename as 'Nominate' , ACXIX100  this has to be rename as 'invest', ACXBX100  this has to be rename as 'Batch;

       

      Sample data and the field name is product

      A2ANAI70

      A2DNDI71

      ACCNDTS0

      ACXBX100

      ACXIX100

       

       

      Regards,

      Nandha