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.)