LTRIM
Description:
The MDX LTrim() function trims all whitespace on the right side of a string.
Syntax:
RTrim ( String_Expression )
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
String_Expression | It is a valid MDX expression that returns a string scalar value on which LTrim function is to be applied. |
Example:
MEMBER [Measures].[Trimmed Name] AS
LTrim(RTrim([Product].[Product].CurrentMember.Name))
SELECT
{[Measures].[First 3 Chars], [Measures].[Last 5 Chars], [Measures].[Name Length]} ON COLUMNS,
[Product].[Product].[Product].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]