InString

The MDX InString function for Essbase returns a number specifying the position of the first occurrence of one string within another.

Syntax

InString (string1, string2, [start] [,compare])

Parameters

string1

String expression or literal string in which to search.

string2

String expression or literal string for which to search.

start

Optional character position to begin search in string1. The default value is 1. A position value of 1 indicates the very first character in the string. If omitted, search begins at first character in string1.

compare

Optional search mode. Values: 0 for case sensitive, 1 for case insensitive. Default is case sensitive.

Notes

If a matching string is not found, the return value is 0.

Example

InString ("Year2000_promotional", "promotional", 5,1)

returns 10

If the start parameter is omitted, the comma before the compare parameter is still required:

InString ("Year2000_promotional", "promotional", ,1) 

If the compare parameter is omitted, the comma before the start parameter is still required:

InString ("Year2000_promotional", "promotional", 5)