Substring

Returns a string that is a substring of the corresponding field input string.

Substring from search string

The substring begins from the characters that are specified as startString and extends to the end of this string.

Function: SUBSTR('startString')

Examples:

"unhappy" - SUBSTR(‘ha’) returns "happy"

"Harbison" - SUBSTR(‘rbi’) returns "rbison"

Parameters:

startString the starting string, inclusive. This input string should be enclosed in single quotes.

Returns:

The specified substring.

Substring from startIndex

The substring begins from the given startIndex and extends to the end of this string.

Function: SUBSTR(startIndex)

Examples:

"unhappy" - SUBSTR(2) returns "happy"

"Harbison" - SUBSTR(3) returns "bison"

Parameters:

startIndex the starting index, inclusive.

Returns:

The specified substring.

Substring from search string to endIndex

The substring begins from the character that are specified as startString and extends to the character at index endIndex – 1.

Function: SUBSTR('startString',endIndex)

Examples:

"unhappy" - SUBSTR(‘ha’,5) returns "hap"

Parameters:

startString the starting string, inclusive. This input string should be enclosed in single quotes.

endIndex the end index, exclusive.

Returns:

The specified substring.

Substring from startIndex to search string

The substring begins from the given startIndex and extends till the given endString of this string.

Function: SUBSTR(startIndex,'endString')

Examples:

"unhappy" - SUBSTR(2, 'ppy') returns "happy"

"Harbison" - SUBSTR(3,‘so’) returns "rbiso"

Parameters:

startIndex the end index, inclusive.

endString the end string, inclusive. This input string should be enclosed in single quotes.

Returns:

The specified substring.

Substring from startIndex to endIndex

The substring begins at the specified startIndex and extends to the character at index endIndex - 1. Thus the length of the substring is endIndex- startIndex.

Function: SUBSTR(startIndex, endIndex)

Examples:

 "hamburger" - SUBSTR(4, 8) returns "urge"
 "smiles" - SUBSTR(1, 5) returns "mile"

Parameters:

startIndex the starting index, inclusive.

endIndex the ending index, exclusive.

Returns:

The specified substring.

Substring between given string inputs

The substring returns the string between given startString and endString i.e. String exclusive of the given string inputs.

Function: SUBSTR('startString', 'endString')

Examples:

"beautiful" - SUBSTR(‘ea’,’fu’) returns "uti"

Parameters:

startString the starting string, exclusive. This input string should be enclosed in single quotes.

endString the end string, exclusive. This input string should be enclosed in single quotes.

Returns:

The specified substring.

Substring to get last index Char Sequence

The substring returns this no. of last char sequence i.e. given length_​of_​char_​sequence for the input string

Function: SUBSTRLAST (length_​of_​char_​sequence)

Examples:

"beautiful" - SUBSTRLAST(5) returns "tiful"

Parameters:

length_​of_​char_​sequence is the no. of char sequence from the end of String.

Returns:

The specified substring.