FIND_EMAIL_FROM Function

43.3 FIND_EMAIL_FROM Function

This function Finds first occurrance of "From: " and the first email after the "From:".

Syntax

FUNCTION FIND_EMAIL_FROM (
    p_string in VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Table 43-3 FIND_EMAIL_FROM Function Parameters

Parameter	Description
`p_string`	The input string.

Returns

This function returns the from address.

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_from(l_string);
    dbms_output.put_line('from = "'||l_result||'"');
end;
/
declare
    l_string  varchar2(32767) := 'Elmar J. Fud <elmar.fud@example.com> wrote:';
    l_result varchar2(4000);
begin
    l_result := apex_string_util.find_email_from(l_string);
    dbms_output.put_line('from = "'||l_result||'"');
end;
/
-> from = "marc.sample@example.com"

Parent topic: APEX_STRING_UTIL