3 Replies Latest reply: Jun 20, 2018 11:12 PM by Thi Pham RSS

    Filter Data

    Andy Manuja

      Hi,

      I got a table which looks like below,

       

        

      Item_CodeItem_Name
      CBDG3CDA
      124567D
      DEFAFDE
      243671G
      ABD256H
      AGHDK2N
      BCDWH5M

       

      I want to filter the data based on the below requirements;

      1. Select the last two characters of the Item_Code. (I may use the Right() function )

      2. I want to Flag/Filter the Item_Codes which ONLY got alphabetic letter. Ex- the last two codes cannot have a number.

       

      The out put should be something like below,

       

        

      Item_CodeItem_Name     Flag
      CBDG3CDA1
      124567D0
      DEFAFDE1
      243671G0
      ABD256H0
      AGHDK2N0
      BCDWH5M0

       

      Could anyone help me to accomplish the above task would be greatly appreciated.

       

      Regards,

       

      Andy