43.8 FIND_TAGS Function

This function finds all strings prefixed with a tag identifier. The search is case insensitive and also ignores white space and special characters.

Syntax

FUNCTION FIND_TAGS (
    p_string          IN VARCHAR2,
    p_prefix          IN VARCHAR2 DEFAULT '#',
    p_exclude_numeric IN BOOLEAN  DEFAULT TRUE )
RETURN apex_t_varchar2;

Parameters

Parameter	Description
p_string	The input string.
p_prefix	The tag prefix (default '#').
p_exclude_numeric	If true (the default), excludes values that only consist of the tag identifier and digits.

Returns

This function returns the found tags in upper case.

Example

DECLARE
    l_tags   apex_t_varchar2;
    l_string varchar2(4000) := 'how now #orclapex @mike brown #cow';
BEGIN
    l_tags := apex_string_util.find_tags(l_string,'#');
    l_tags := apex_string_util.find_tags(l_string,'@');
END;
/
-> apex_t_varchar2('#ORCLAPEX','#COW')
-> apex_t_varchar2('@MIKE')