Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Roi appreciate ur help