FIND_EMAIL_SUBJECT Function

56.4 FIND_EMAIL_SUBJECT Function

This function finds the subject text in a given email string.

Syntax

APEX_STRING_UTIL.FIND_EMAIL_SUBJECT (
    p_string IN VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Parameter	Description
`p_string`	The input string.

Returns

This function returns the subject line.

Example

declare
    l_string varchar2(32767) := 'From: Marc Sample <marc.sample@example.com>'||chr(10)||
                                'Subject: Status Meeting'||chr(10)||
                                'Date';
    l_result varchar2(4000);
begin
    l_result := apex_string_util.find_email_subject(l_string);
    dbms_output.put_line('Subject = "'||l_result||'"');
end;
/
-> Subject = "Status meeting"

Parent topic: APEX_STRING_UTIL