MicroStrategy ONE

Replace

The Replace function searches a string for a pattern of characters and replaces each instance of those characters with the new characters you specify. The resulting string with all instances replaced is returned.

Syntax

Replace(Argument, Find, Replace)

Where:

  • Argument is a metric, fact, column, or string representing the text strings that are searched.
  • Find is a metric, fact, column, or string representing the text strings that are searched for within the strings returned by Argument.
  • Replace is a metric, fact, column, or string representing the text strings that are used to replace any instances of the string from Find that are included in the strings returned by Argument.

For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds to your database.