jeffamm Posted August 16, 2020 Share Posted August 16, 2020 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 Link to comment Share on other sites More sharing options...
This topic is 1028 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now