Title
Pattern Counts evaluates on one but not the other
Post
I'm using the script at the bottom.
The script step in blue evaluates. The one in Red does not.
If i take one of the lines from the Blue and paste it to the Red, it does not evaluate.
I've looked at it several times. I can't see why.
What am i missing?
Could the parameters be reversed?
The syntax is:
PatternCount ( "LargeString" ; "ShortString" )
And returns the number of times that "shortString" is found in "Large String". So you'd bet a result of zero if you used:
PatternCount ( "Apple" ; "AppleSauce" )
when you should have used:
PatternCount ( "AppleSauce" ; "Apple" )
The other situation would be a case where the quoted text used is not correct in some small, hard to use way such as an extra space or a tab character in one field/string and the same character in the other field/string is a space...