PatternMatchesEndsWith (MDX+)

A example checking the string expression ends with the "ris" pattern.
The default behavior is case-sensitive.

Query

PatternMatchesEndsWith( "ris", "Paris" )

Result

Assertion : MDX Equals

true

Assertion : MDX Equals

PatternMatches( ".*ris$", "Paris" )

A simple example checking the string expression ends with the "RIS" pattern.
The default behavior is case-sensitive.

Query

PatternMatchesEndsWith( "RIS", "Paris" )

Result

Assertion : MDX Equals

false

A example checking the string expression ends with the "RIS" pattern.

Query

PatternMatchesEndsWith( "RIS", "Paris", CASE_INSENSITIVE )

Result

Assertion : MDX Equals

true

Assertion : MDX Equals

PatternMatches( "(?i).*RIS$", "Paris" )

A example searching for the " character. Notice how the character is being escaped (doubling it) in the pattern expression

Query

PatternMatchesEndsWith( """2020""", 'Phones "2020"')

Result

Assertion : MDX Equals

true