topic Re: extract email id from string in Application Development and Automation Discussions

extract email id from string

purva_01 — Thu, 28 Dec 2023 11:14:48 GMT

How to extract multiple EMAIL ID from text using sap abap code

Example : This is my 2 EMAIL ID ABC@gmail.com and XYZ@yahoo.co.in.please send me also on my another email ID LMN@hotmail.com.

It should extract exact email.ID without any '.' or space

output should be below

ABC@gmail.com

XYZ@yahoo.co.in

LMN@hotmail.com

Re: extract email id from string

Sandra_Rossi — Thu, 28 Dec 2023 11:46:36 GMT

Use regular expressions, the Web is full of examples for emails.

Re: extract email id from string

abo — Thu, 28 Dec 2023 16:04:05 GMT

statistically speaking, most of those examples are wrong or incomplete.... but that is precisely part of the charm of regexp 😉

Re: extract email id from string

Sandra_Rossi — Thu, 28 Dec 2023 17:16:13 GMT

c5e08e0478aa4727abc4482f5be390b2 or it is the charm of searching, few answers wrong, one answer right, and that's it. Statistically, the answers to this question would be "most of answers would be wrong or incomplete anyway", so why asking 😉

Re: extract email id from string

abo — Thu, 28 Dec 2023 17:47:54 GMT

behold the power of googling 😄

Re: extract email id from string

Harish_Vatsa — Thu, 28 Dec 2023 17:53:46 GMT

Dear purva_01,

Please try with the following regex:

(?i)\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}\b

There can be some edge-case scenarios that you might need to adjust.

Re: extract email id from string

Sandra_Rossi — Thu, 28 Dec 2023 18:23:57 GMT

Invalid for POSIX, but fine for PCRE.

LOL about the OP test case, see "please" 😉

Re: extract email id from string

ameya_2023 — Sun, 31 Dec 2023 08:52:57 GMT

Hello,

While this answer might not be what you initially hoped for, it sparked my curiosity and prompted me to test the capabilities of the Vertex AI Language Model.

Test1: In the prompt, I simply entered the same text and the model correctly identified that "please" is not part of the email address.

Test2: I altered the following text, simulating a possible variation in how someone might write email addresses in chat or email. This is an example of an edge case for testing. As LLM models can interpret natural language style of writing to a significant extent, the model was able to still identify the 3rd email ID.

If this meets your needs, consider trying this option or just explore for curiosity. Learn more here on how you can utilize this in ABAP.

Regards,

Ameya

Re: extract email id from string

Sandra_Rossi — Sun, 31 Dec 2023 09:45:39 GMT

Disclaimer: the link is an article from the author.