12 Replies Latest reply: Aug 25, 2015 4:07 AM by Richard Chilvers RSS

    String Aggregation Function for matching text

    Richard Chilvers

      My data looks like:


      Code, Description, Value


      ABC, 20% discount , £100

      ABC, 20% discount voucher, £200

      ABC, 20% discount with money back, £140

      DEF, another discount, £20




      I have a straight table chart to aggregate (SUM) values by Code:


      ABC £340

      DEF £20




      Is there a string function to show the first n matching characters in Description?

      Eg. ABC, 20% discount, £340