FIND function

This topic describes the formula syntax and usage of the FIND function in the Data Quality Execute Formula transform.

Description

Finds one text value within another (case-sensitive). The function returns the number of the starting position of the first text string from the first character of the second text string.

Syntax

FIND(find_text, within_text, [start_number])

find_text Required. The text to be found.
within_text Required. The text to be search.
start_number Optional. Specifies the character position at which to start the search, starting with 1. The default if omitted is 1.

Notes

This function may not be available for all languages.
FIND is intended for use with languages that use the single-byte character set (SBCS).
FIND always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.

Examples

Data:

Adromeda Galaxy

in the Astronomy field.


Formula	Description	Result
`FIND("A",[Astronomy])`	Position of first "A" in the Astronomy field	1
`FIND("a",[Astronomy])`	Position of first "a" in the Astronomy field	8
`FIND("A",[Astronomy],9)`	Position of second "a" in the Astronomy field	11