Share via


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"