I have a calculation field that is suppose to search for a string within a
field, and assign a value if it finds it, otherwise assign another value.

CMycalField =
If (AdOrder = "*trk*", 2, 1)

Where the result is a number.
I was hoping to find the letters "trk" somewhere in the field and if found
assign 2 to CMycalField, if not assign 1. It assigns everything 1.

Can someone help clarify this for me

Thanks

Henry <henry_filemaker (AT) hotmail (DOT) com> wrote:

If(Patterncount(Fieldname, "trk") = 1, 2, 1)


--
Lynn Allen Allen & Allen Semiotics
FSA Associate Filemaker Consulting & Training
lynn (AT) semiotics (DOT) com http://www.semiotics.com

Lynn allen <lynn (AT) NOT-semiotics (DOT) com> wrote:

What if there are multiple occurrences of the string "trk"?
If(PatternCount(Fieldname, "trk"), 2, 1)

--
Henk B