7 Replies Latest reply: Feb 1, 2017 1:46 PM by Sunny Talwar RSS

    How to use RIGHT() for string value?

    Jim Chan

      Hi guys,

       

      i have data as such AB_apple, AB_orange,AB_lemon, CD_chicken, CD_Beef, CD_Fish.

       

      my expected result is i only want to show result - apple, orange,lemon WITHOUT the AB_ ?

       

      I have  tried to write this expression, it didnt work.

       

      if(right(fieldname,3)='AB_' ,fieldname)

       

      HElp pls!

       

      Rgds

       

      Jim