Pattern Counts evaluates on one but not the other
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?
The script step SetVariable [$DescriptionIDPopUp evaluates each time. If i had it reversed neither one would work... correct???
When i put one of the strings from the "PopUP" into the "bad" one it does not work...
Ill look for syntax in the one that does not evaluate.
If i take the 1st line from the bad one and paste it to the good one, it evaluates...
Ill try each one from the bad until i find it.
Sorry, can't follow your descriptions. My suggestion is basically that PatternCount is returning zero when you are expecting a number then then the Case function won't return any value. I can't see what data is in the field no how it is formatted so I'm suggesting you check it and the quoted data both very carefully.
But you are now trying a version of what I would do to chase this one down: I'd break this complex calculation down into smaller pieces and see if I can isolate the part or parts that are not evaluating correctly.
i am stupid.
i put both of the set variables together... the second one cancels out the 1st.
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...