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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-29 UTC."],[[["\u003cp\u003eThe \u003ccode\u003eSUBSTRING\u003c/code\u003e function extracts a portion of a string based on specified start and end index values.\u003c/p\u003e\n"],["\u003cp\u003eIt requires two arguments: the start index and the end index, to define the substring boundaries.\u003c/p\u003e\n"],["\u003cp\u003eThe function's input and output are limited to the String data type.\u003c/p\u003e\n"],["\u003cp\u003eFor example, \u003ccode\u003e"$var1$.SUBSTRING(1, 5)\u003c/code\u003e on the string \u003ccode\u003eHelloApigee\u003c/code\u003e will result in the output being \u003ccode\u003eello\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# SUBSTRING function\n\nSee the [supported connectors](/integration-connectors/docs/connector-reference-overview) for Application Integration.\n\nSUBSTRING function\n==================\n\n`SUBSTRING` function\n--------------------\n\nSupported data type\n-------------------\n\n\nThe `SUBSTRING` function supports the following data type:\n\n- String\n\nExample: Return the substring of the current string, beginning with the character\nat the start index number and ending prior to the character of the end index number.\n----------------------------------------------------------------------------------------------------------------------------------------------------------------------\n\n\n**Sample data** : `$var1$ = \"HelloApigee\"`\n\n\n**Usage** : `$var1$.SUBSTRING(1, 5)`\nReturn the substring of var1.\n\n\n**Output** : `ello`\n\nRecommendation\n--------------\n\n- Learn how to add and configure a [Data Mapping task](/application-integration/docs/configure-data-mapping-task)"]]
