5 Replies Latest reply on Jan 6, 2015 7:25 AM by kettan

    How to find the number of occurrences of all sub-strings in all strings of a particular dimension?

    Charles George

      Sample data given below:

      ItemName Dimension in the row shelf

       

      Row 1: ABC DEF XYZ

      Row 2: ABC XYZ

      Row 3: ABC PQR XYZ

      Row 4: ABC DEF PQR XYZ

      Row 5: ABC DEF

       

      The output should ideally look like this:

      ABC 5

      DEF 3

      PQR 2

      XYZ 4