2 Replies Latest reply on Sep 24, 2012 10:45 AM by Michael Sonu

    find string thru if and find condition

    Michael Sonu
      Order #option string

      Total

      AABC,RTF,DFG,AGH1
      BAFG,TYR,AGH,ABC1
      CDFG,ART,KUY

      0

       

      Hi All,

       

      I have a table like above and want to check how many orders have AGH; the answer is 2.

       

       

      The same way for DFG is also 2.

       

      Order #option string

      Total

      AABC,RTF,DFG,AGH1
      BAFG,TYR,AGH,ABC0
      CDFG,ART,KUY

      1

       

      But i want to calculate the same thru a filter where you can enter the RPO manually and it should perform the calulation.

       

      Regards,

      Michael