Requirement:
If anyone has come up with a formula in saves searches that identifies the number of occurrences a number/word appears in a sting of a field?
I would like to know how many times “529” appears in this field
Answer:
You can try this formula:-
(LENGTH({yourtextfieldid}) -LENGTH(REPLACE({yourtextfieldid}, ‘529’, ”)))/LENGTH(‘529’)
