AnsweredAssumed Answered

How to get the occurrence of string in calculation engine?

Question asked by user2147901 on Oct 16, 2018
Latest reply on Oct 16, 2018 by user19752

Hi I am new to filemaker, is it possible to get the occurrence of specific string in calculation engine? For example, I have a following string. I will make some changes for the words "apple", in fact all of them are "apple"

 

I love Apple so I eat aPple everyday. however, I like red apPle rather than green appLe.

 

so is it possible to know their corresponding occurrence?

 

Apple : 1

aPple : 2

apPle : 3

appLe : 4

 

I am using filemaker 17.

Outcomes