5 Replies Latest reply: Sep 4, 2012 6:20 AM by Anna Perini RSS

    Substringcount function.-

    Anna Perini

      Goodmorning, someone is able to help me to answer this question: can SubStringCount extract more than a value from a concatenation of numbers?

      as this: 

       

      SubStringCount of(Concat(_metricsNo, '|'), 1 and 5 and 7).

       

      I tried in different ways but i can't find a solution maybe substring isn't the right funciont for my purpose.

      Thank you

      Anna