SUBSTRING function

SUBSTRING function

Function Name	Description	Usage	Input parameter	Return value
SUBSTRING	Returns the substring of the current string from the start index inclusive to the end index exclusive.	SUBSTRING(value, value)	This function takes the following arguments: First argument: Start index value. Second argument: End index value.	String between the start and end indexes.

Supported data type

The SUBSTRING function supports the following data type:

• String

Example: Return the substring of the current string, beginning with the character at the start index number and ending prior to the character of the end index number.

Sample data: $var1$ = "HelloApigee"

Usage: $var1$.SUBSTRING(1, 5)

Return the substring of var1.

Output: ello

Recommendation

• Learn how to add and configure a Data Mapping task