7 Replies Latest reply: Aug 13, 2015 2:45 PM by Srikanth P RSS

    Only get certain characters from a field

    Yvonne Han

      Hi

       

      I have a field with values shown below. Is there a way to write a script to only get the ID after the last '_' sign as shown in the ID column?

       

      Value

      ID

      MCS_NY_2523_B12

      B12

      INC_NJ_2522_A1

      A1

      RETDS_BY_LO__TIM_S130

      S130