Locate

Locate: Returns the numerical position of a character string in another character string.

Syntax: LOCATE(expr1, expr2)

Syntax description

expr1 is any expression that evaluates to a character string. Identifies the string for which to search.

expr2 is any expression that evaluates to a character

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on String folder and select Locate

Example: Locate('a',"Date (Common)"."Month Name")