Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The BLANKSTRIP function removes leading or trailing blank spaces from text values. BLANKSTRIP is useful for such purposes as removing unwanted blank spaces from fixed-length fields in an imported worksheet.
Return Value
TEXT or NTEXT
Syntax
BLANKSTRIP(text-expression [TRAILING|LEADING|BOTH])
Arguments
A text expression from which to remove blank spaces. When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.
Removes blank spaces at the end of the text.
Removes blank spaces at the beginning of the text.
Removes both leading and trailing spaces.
Examples