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



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"