snowflake.snowpark.functions.substr¶

snowflake.snowpark.functions.substr(str: ColumnOrName, pos: Column | int, len: Column | int) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L1793-L1809)¶

Returns the portion of the string or binary value str, starting from the character/byte specified by pos, with limited length. The length should be greater than or equal to zero. If the length is a negative number, the function returns an empty string.

Note

For pos, 1 is the first character of the string in Snowflake database.

substr() is an alias of substring().