INSTR_UDF (STRING, STRING, DOUBLE, DOUBLE)

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

This is the user-defined function (UDF) overloaded with four parameters.

Definition

Searches the source_string argument for occurrences of searh_string.

PUBLIC.INSTR_UDF(SOURCE_STRING STRING, SEARCH_STRING STRING, POSITION DOUBLE, OCCURRENCE DOUBLE)

Parameters

SOURCE_STRING STRING

The string where the search will be conducted.

SEARCH_STRING STRING

The string that the function searches for.

POSITION DOUBLE

The character index where the search will start (starting at 1).

OCCURRENCE DOUBLE

The character index where the search will start (starting at 1).

Returns

The position in the source string where the occurrence is found.

Usage example

Input:

SELECT INSTR_UDF('CHOOSE A CHOCOLATE CHIP COOKIE','CH',2,2);

Output:

20