finding part of a word in a field

[dylanls]

I need a very simple step but i just cant figure out how to do it.

I have a field called NAME with the following value:

johncartreehouse

in a calculation field, i want the value "true" if the word car is found in NAME

can somebody tell me how this can be done?

i tried many things but i cant figure out how to search for a string of text.

Thanks in advance!

[comment]

Try the PatternCount() function. Where is the string "car" coming from?

[dylanls]

To explain in more detail what i want, i am making a URL generator

The flags in the url should be set according to the product found in the name field

So, does it contain car? value = 1

does it contain house? value = 2

etc

[dylanls]

patterncount seems to do the trick for me, anyway!

Thanks a lot!