How to extract a certain text from a paragraph after a keyword?

[tadjus]

I need to extract tons of emails on info regarding the IP Address, Hosting Provider, and Abuse contact. As shown here:

Cloudflare received your trademark infringement complaint regarding: website
Cloudflare offers network service solutions including pass-through security services, a content distribution network (CDN) and registrar services. Due to the pass-through nature of our services, our IP addresses appear in WHOIS and DNS records for websites using Cloudflare. Cloudflare cannot remove material from the Internet that is hosted by others.

    IP Address: 1.2.3.4
    Hosting Provider:
    -----------------
    Hosting Provider Name
    Abuse Contact:
    --------------
    hostingprovideremail

We have notified our customer of your report.
We have forwarded your report on to the responsible hosting provider.
You may also direct your report to:

1. The provider where web is hosted (provided above);
2. The owner listed in the WHOIS record for web and/or;
3. The contact listed on the web site.
   Note: A lookup of the IP for a Cloudflare customer website will show Cloudflare IPs because we are a pass-through network. The actual website is still hosted at the hosting provider indicated above. If the hosting provider has any questions, please have the hosting provider contact us directly regarding this site. Due to attempted abuse of our complaint reporting process, we will only provide the IP of web to the responsible hosting provider if they contact us directly at abusereply
   Regards,
   Cloudflare Trust & Safety

Is there any way to store text only on those three? Thanks!

[newuserkantu]

You can try to study this example and adapt it for your case

Copy from the text based website

{ "Name": "teeeeeest", "CreationDate": "2023-5-31", "Commands": [ { "Command": "executeScript", "Target": "const table = document.querySelector(\"pre\").innerHTML.match(/(\\d{4}\\.\\d{2}\\.\\d{2}).*İlksel$/gm)\n\nreturn table", "Value": "table", "Description": "" }, { "Command": "forEach", "Target": "table", "Value": "item", "Description": "" }, { "Command": "echo", "Target": "${item}", "Value": "", …

Alternative solution is store all the text and after cut the part with split function

Split and/or Trim

Split code working like a charm tested ! { "Name": "Split_Function", "CreationDate": "2019-10-26", "Commands": [ { "Command": "store", "Target": "11111-22222", "Value": "Col" }, { "Command": "executeScript_Sandbox", "Target": "return ${Col}.split(\"-\")[0].trim();", "Value": "First_Part" }, { "Command": "echo", "Target": "${First_Part}", "Value": "" }, { "Command": "executeScript_Sandbox", "Targe…

[tadjus]

Hey hey, thanks for the solution. Definitely will try it out. However, my current workaround is to store the whole email body and split them manually in Excel while clearing out the unnecessary words. Since the body is using the exact same format, it’s easy.