43.13 REPLACE_WHITESPACE Function

This function can be used to tokenize the input. It replaces white space and special characters with the given whitespace character. It also lower-cases the input. If p_original_find contains '.' or '#', these characters are also replaced by white space.

Syntax

FUNCTION REPLACE_WHITESPACE ( 
    p_string               IN VARCHAR,
    p_original_find        IN VARCHAR2 DEFAULT NULL,
    p_whitespace_character IN VARCHAR2 DEFAULT '|')
    RETURN VARCHAR2;

Parameters

Table 43-10 REPLACE_WHITESPACE Function Parameters

Parameter	Description
p_string	The input string.
p_original_find	A set of characters that were already found in a preceding search operation.
p_whitespace_character	The separator character.

Returns

This function returns the input string in lower case with all special characters replaced.

Example

select apex_string_util.replace_whitespace('foo: Bar...Baz') from dual
-> |foo|bar|baz|
select apex_string_util.replace_whitespace('foo: Bar...Baz',null,'*') from dual
-> *foo*bar*baz*
select apex_string_util.replace_whitespace('foo: Bar...Baz','.','*') from dual
-> *foo*bar...baz*