GetEmailFromGmail ( ListOfMails )

Extract emails from GMAIL API raw

Be the first to rate this function Log in to vote

Angel S. Murcia - Show more from this author
Lesterius

Sample input:

GetEmailFromGmail ( Angel < angel@domain.es >,Fran < francisco@domain.es >,Angel M < angelm@domain.es > )

Sample output:

angel@domain.es¶francisco@domain.es¶angelm@domain.es

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Extract emails from GMAIL - Angel S. Murcia v0.2
Example Angel <angel@domain.es>,Fran <francisco@domain.es>, Angel 
M <angelm@domain.es>, Alexis <alexism@domain.es>

Result angel@domain.es¶francisco@domain.es¶angelm@domain.es¶alexism@domain.es
*/

Let ( 
[ 
ListOfMails = Substitute ( ListOfMails ; "," ; ¶ );
listMails = ListOfMails;
listItem = GetValue ( listMails ; 1 );

positionLeft = Position ( listItem ; "<" ; 1 ; 1 );
positionRight = Position ( listItem; ">" ; 1 ; 1 );
mail = Middle ( listItem ; positionLeft + 1 ; positionRight - positionLeft - 1);

listMails = If ( PatternCount ( listItem ; "<" ) = 1 ; listMails & "¶" & mail; listMails & "¶" & listItem ) ;

lista = LeftWords ( listMails ; Length ( listMails ) ) ;
totalvalues = ValueCount ( lista );
index = 1;

getList = 
        Case ( 
            index < 1 or index > totalvalues ; lista ;
            LeftWords ( LeftValues ( lista ; index - 1 ) & MiddleValues ( lista ; index + 1 ; Length ( listMails ) ) ; Length ( listMails ) 
         )



)


] ; 

If ( PatternCount ( GetValue ( getList ; 1 ) ; "<" ) = 1  ; GetEmailFromGmail (getList) ;  TrimAll ( getList ; 0 ; 1 ) )

 )

This custom function its to extract the email return from the API when you get the mails from GMAIL.

Note: Something error was happen in the briandunning post, i cant introduce the correct sample input, i was need add space between character "<" and ">"

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetEmailFromGmail ( ListOfMails )

Comments

Support this website.

Support this website.