36.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 wwv_flow_t_varchar2;
Parameters
Table 36-8 FIND_TAGS Function Parameters
Parameter | Description |
---|---|
|
The input string. |
|
The tag prefix (default ' |
|
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