Embarrassingly simple problem

[Philip Jenks]

Hi

I'm trying to write a script which says:

"If [ProductName] includes the word "Jacket"; .36; .15"

where the numbers are the weights of packaging used in sending the garments. "Jackets" use packaging that weighs 360g. All other products use packaging that weighs 150g.

I don't know how to write the "includes" bit. The word Jacket could appear at the beginning of middle or end of the Product Name.

Any clues?

Thank you.

[comment]

Try the PatternCount() function? Note that it looks for a string, which is not the same thing as a word.

It would be probably best to have dedicated field for the product type.

[Philip Jenks]

It works! Thank you 'consultant'.