Left/Right/Mid
Left
, Right
, and Mid
allow you to trim text from the results of other text functions such as MemberAlias and MemberName to keep only the left-most, right-most, or center text.
Syntax
Left (text, [number_of_characters])
Right (text, [number_of_characters])
Mid (text,start_position, [number_of_characters])
Note:
"number_of_characters" is optional for the Mid
function.
Examples
On a row segment with Accounts (MemberAlias(Accounts) = "10000 - Net Income"
)
Left(MemberAlias(Accounts), 5)
yields 10000.
Right(MemberAlias(Accounts), 6)
yields Income.
Mid(MemberAlias(Accounts), 9)
yields Net Income. (In this example, 9 is the starting position for the Mid function.)