1

Is there a way to match multiple occurrences of string A in string B? Match only returns a boolean and Pos only returns the index of the first match it finds.

Maybe split the string into an iterable array based on a common delimiter and return a count somehow?

Improve this question
2
  • Could you break string A into smaller chunks and search each chunk?
    – jesstme
    Commented Feb 22, 2017 at 16:57
  • hi @jesstme Thanks for chiming in. See solution below.
    – Karl Pokus
    Commented Feb 23, 2017 at 14:20

1 Answer 1

Reset to default
1

Well this is one way to solve it. It's not pretty but it works.

=(Length([stringB]) - Length(Replace([stringB];"stringA";""))) / Length("stringA")

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.