2 Replies Latest reply: Jun 21, 2018 2:01 AM by Nitin Gaikwad RSS

    Filter the field data based on a particular value

    Andy Manuja

      Hi,

      Got a new question going slightly beyond the question I asked in the morning.

      Assume the table I am referring looks as below,

       

        

      Item_CodeItem_Name
      CBDG3CDA
      124567D
      DEFACDE
      243671G
      CDH
      AGHDK2N
      CDM

       

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

      1. Select the last two characters of the Item_Code.

      2. I want to Flag/Filter the Item_Codes which ONLY got "CD" letters at the END.

       

      Note

      Item_Code could just "CD" or it could be the last two letters of a text value.

       

      The out put should be something like below,

       

        

      Item_CodeItem_Name     Flag
      CDBG3CDA1
      124567D0
      DEFACDE1
      CD3671G0
      CDH1
      AGHDK2N0
      CDM1

       

      Could anyone help me with the above task, would be greatly appreciated.

       

      Regards,

       

      Andy