SUBSTRING

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.

Applies to

SQL Server
Azure Synapse Analytics

Description

Returns a character expression after it removes leading blanks (RTRIM in Transact-SQL).

Sample Source Pattern

Syntax

SUBSTRING( string_expression, start, length )

Examples

Input:

IN -> SQLServer_01.sql

SELECT SUBSTRING('abcdef', 2, 3) AS SOMETEXT;

Output:

SOMETEXT|
--------+
bcd     |

Code:

CREATE OR REPLACE FUNCTION REPLACER_LENGTH(str varchar, index float, length float)
  RETURNS string
  LANGUAGE JAVASCRIPT
AS
$$
    var start = INDEX - 1;
    var end = STR.length - (LENGTH - 1);
    return STR.substring(start, end);
$$;

SELECT REPLACER_LENGTH('abcdef', 2, 3) AS SOMETEXT;

Result:

SOMETEXT|
--------+
bcd     |

Known Issues

No issues were found.

No related EWIs.

Previousstringify in JS NextTRIM

Last updated 4 months ago

Description

Sample Source Pattern

Syntax

Examples

Known Issues

Related EWIs