Saved Search – Count the number of occurrences in a text field

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

image.png

Answer:

You can try this formula:-

(LENGTH({yourtextfieldid}) -LENGTH(REPLACE({yourtextfieldid}, ‘529’, ”)))/LENGTH(‘529’)

Leave a comment

Your email address will not be published. Required fields are marked *