Jump to content

Recommended Posts

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 post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.