PatternCount not working

[jeffamm]

I'm using FM Pro 14 Advanced with a stand-alone desktop database

Trying to get a count of "|" characters in field VARIATION RELATIONSHIP DETAILS so using

PatternCount ( "|" ; VARIATION RELATIONSHIP DETAILS )  where the field for a given record is:   "Length=1 ft | Color=Black"

The function is returning "0" when to my understanding it should return "1"

Calculation result is set to Number

I have tried it with other strings and fields and am always getting "0"

Anyone know why? Does this function only work with multiple characters ( a pattern)? Is there a better way to get a count of specific characters in a string?

Sorry to be a dummass

thanks

[comment]

You have the arguments backwards. Try:

PatternCount ( VARIATION RELATIONSHIP DETAILS ; "|" )

 

[jeffamm]

Ack!  Thank you!