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
    Posts
  • #667

    dtaylor
    Participant

    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.

    Thanks

    Dan

    #5561

    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.