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!