If Field Contains Formula

Home Forum Formula and Condition Editor If Field Contains Formula

This topic contains 1 reply, has 0 voices, and was last updated by  dtaylor 7 years, 11 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #667


    Is it possible to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain word e.g. IF this statement in Field 1 contains the word “dog”, write “dog”, otherwise, write nothing.

    I went to the pet store and I bought some dog food.




    The formula function called Index Of:

    Searches for an occurrence of the text string (search text) within another string (text) and returns the starting position of any matching occurrence. The first character in the text is position 0. A return position of -1 indicates that search text was not found.

    Use Index Of in a simple branch behavior object.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.