SUBSTRING (Report Builder 1.0)
Returns a substring from within a string.
Syntax
SUBSTRING(string, start, length)
string |
Specifies the string from which a substring is extracted. |
start |
Specifies the start position within the string. |
length |
Specifies the number of characters. |
Example
Formula |
Result |
|---|---|
SUBSTRING(Address Line, 5, 20) |
Returns a substring for each instance of the Address Line field that begins at the fifth character of the string and ends at the 20th character. For example, the following string: "#9900 2700 Production Way" returns the following substring: "0 2700 Production Wa". |
SUBSTRING("lavender", 3, 5) |
"vende" |