Number repetition in the value

[shumailh]

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

[lironbaram · Accepted solution]

hei

attch is example of what you asked for

i am using two function:

1.SubStringcount- Counting how many time a substring appears in a string

2.wildmatch

hopes its helps you

[shumailh]

Thanks Roi appreciate ur help