Calculation help

[Ronzues]

I am needing to set up a field based on this calculation.

If "field 1" contains "insert" then "Ins"

I know for the most part how to do the If(then) calcs but I am not sure how to make it look for a string of text in field 1. I can't use the "=" operator because field 1 can contain more data than just "Insert". It could say "Insert1", "cd Insert", "BRC Insert" etc.

It could also contain data that doesn't have the word "insert" in it at all.

Please help.

[mav]

I might be leading you down the wrong path, as I'm only familiar with FileMaker 7 and up, but I would use

If ( field 1 = "insert"; result )

[LaRetta]

field 1 can contain more data than just "Insert". It could say "Insert1", "cd Insert", "BRC Insert" etc.

You need Position() or PatternCount() text calculation here. Position is faster. If the word 'Insert' appears anywhere in field1, this calc will fire on it.

Case ( Position( field1 , "Insert" , 1 , 1 ) , "Ins" )

LaRetta :wink2: