AnsweredAssumed Answered

Look for matching whole word in a calculation

Question asked by foursheds on Oct 11, 2017
Latest reply on Oct 12, 2017 by beverly

Hi

 

Inside a calculation I want to look for "son" as a whole word

 

e.g.  PatternCount( "something son something"; "son");     should return 1

 

but   PatternCount( "something clarkson something"; "son");     should return 0

but   PatternCount( "something sonic something"; "son");     should return 0

 

 

I thought there might be a way to do it by matching Length(text) , i.e. son = 3 , clarkson = 8,

but can't find a way to get the possible match word, e.g "clarkson" as I won't know the word position.

 

 

If it matters, this calculation is part of a script that loops through all records and sets another field accordingly whenever it finds a "son"

 

 

Thanks

 

Joe

Outcomes