41.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')
Parent topic: APEX_STRING_UTIL