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.