|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
Tip:When you are using a multibyte character set, you can use the REMBYTES function instead of the REMCHARS function.
TEXT or NTEXT
REMCHARS(text-expression start [length])
The expression from which REMCHARS removes characters. When the characters to remove from text-expression contain embedded line breaks, these breaks are also removed. Other line breaks are preserved. Removed line breaks are not counted toward the total number of characters removed.
When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.
INTEGER that represents the character position at which to begin removing characters. The position of the first character in text-expression is
1. When the value of start is greater than the length of text-expression, REMCHARS simply returns text-expression.
INTEGER that represents the number of characters to be removed. When length is not specified, only the character at start is removed.
Example 8-72 Using REMCHARS to Remove a Substring
This example shows how to remove the substring
there from the text value
SHOW REMCHARS('hellotherejoe', 6, 5)