SEARCH Operation

How to use the SEARCH operation for Computed Attributes

Definition

The SEARCH operation finds the first position of a string found in a text. This is not case sensitive. 

Example

SEARCH(“lo”,”HELLO WORLD”)

Result:
4

Syntax Guide

SEARCH(search_for, text_to_search, [starting_at])

search_for - The string to look for within text_to_search.

text_to_search - The text to search for the first occurrence of search_for.

starting_at - [ OPTIONAL - 1 by default ] - The character within text_to_search at which to start the search.