2 Replies Latest reply: Jan 17, 2011 8:27 AM by Shumail Hussain RSS

    Number repetition in the value

      I am looking for a function which allow me to identify the number of repitition of 3 in a value of field "Performance" also the value should not contains greater then 3 number. for example

      Performance RESULT
      Value 1: 000111122322232221111 3 IS REPETING MORE THEN 1 TIME SO RESULT SHOULD BE "NO"
      Value 2: 000123456789999999999 VALUE CONTAIN GREATER THEN 3 VALUE SO RESULT SHOULD BE "NO"
      Value 3: 000100000001222220001 RESULT IS "YES" AS THE VALUE DOES NOT CONTAIN GREATER THEN 3 NUMBER
      Value 4: 000111112222223221121 SAME AS ABOVE RESULT SHOULD BE YES AS VALUE CONTAIN REPETITION OF 3 AT ONCE

      Would appreciate your help on the above query

      Shumail