Need JMP formula to count occurrence of a particular character or characters in a string

["James T Metz" <james.metz@abbott.com>]

JMP Users,

        Can someone please help.

        I am trying to create a JMP formula which will count the occurence(s) of a character or small group of characters in
a string.  For example, I would like to count the number of "{" left squiggle braces in a character string.  

        Another example, I would like to be able to count the number of occurences of "C1ccC1" in a character string.

        I would be most grateful if someone could figure out a row formula how to do this.

        Thank you.

        Regards,
        Jim Metz


James T. Metz, Ph.D.
Research Investigator Chemist

GPRD R46Y AP10-2
Abbott Laboratories
100 Abbott Park Road
Abbott Park, IL  60064-6100
U.S.A.

Office (847) 936 - 0441
FAX    (847) 935 - 0548

james.metz@abbott.com

This communication may contain information that is legally privileged, confidential, or exempt from disclosure.  If you are not the intended recipient, please note that any dissemination, distribution, use, or copying of this communication is strictly prohibited.  Anyone who receives this message in error should notify the sender immediately by telephone or return email and delete it from his or her computer.