11 Replies Latest reply: Jun 20, 2018 2:59 AM by Andy Manuja RSS

    Selecting alphabetical letters from a mix of letters and numbers

    Andy Manuja

      Hi,

      I got a filed named "ITEM_CODE" which got both numbers and alphabetic letters in it.

       

      I need to filter the data rows which only got letters.

       

      Please find a sample data set load code below,

       

      Table:

      Load * Inline [

      Item_Code, Item_Name

      CBDGHD, A

      124567,C

      DEFAFD,D

      243671,E

      147568, H

      ABDPOL,G

      ]

       

      Appreciate if anyone could propose me a method to filter only the rows which got alphabet letter ( according to the scenario 3 instances) from the entire data set.

       

      Awaiting for your reply.

       

      Thanks in advance

       

      Regards,

      Andy