5 Replies Latest reply: Feb 24, 2015 5:51 AM by Onno van Knotsenburg RSS

    Count of distinct serial numbers, some with extensions

      Hi All,

       

       

      I need your help with an expression. Currently I am trying
      get a count of distinct serial numbers, but some of my serial numbers are
      listed as

       


      N10HPDMM8



      N10HPDMM8_EXPLODED_20131007070719


       

       

      So the expression sees these as 2 distinct serial numbers. But
      I need these to be seen as the same SN. How can I get my expression to read these as 1
      distinct serial number?