5 Replies Latest reply: Feb 17, 2017 6:01 AM by Nithyakala R RSS

    Trim last Part of text field put it as a new field

    Nithyakala R

      Team,

          

       

      Fieldcomment
      1

      Working on support_ALM1234,

           Working on Read rate_SLA345

      2

      support process_IN4353,

      Billed 100%_ALM234

      3

      Working on issues_ALM2357,

      working on Support_IN56452

       

      from the table i want to result should be  trim the value after '_'  value as a new field.

      For example:

           desired output should be like following below:

          

      fieldcommentTicket ID
      1Working on supportALM1234
      1Working on Read rateSLA345
      2support processIN4353
      2Billed 100%ALM234

       

      Please suggest.