Specific text to excel

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
jpf1281
Newbie
Posts: 15
Joined: Mon Jun 14, 2021 1:40 pm

Specific text to excel

Post by jpf1281 » Tue Jan 14, 2025 6:56 pm

Hi,
I am currently trying to create an automation that will look for specific text in a .xml file and enter that text into the first row in an excel doc. I am looking to get a list of any email addresses in the file that do not have a particular domain extension. I am using Readfile and Position and looping through the file to find the email addresses, but I am not sure how to get the output result that I am looking for. Any help would be appreciated.

User avatar
Dorian (MJT support)
Automation Wizard
Posts: 1411
Joined: Sun Nov 03, 2002 3:19 am

Re: Specific text to excel

Post by Dorian (MJT support) » Tue Jan 14, 2025 7:15 pm

You can use Regex with easypatterns to extract email addresses from text. There's a specific example here.

Then use XLSetCell to output to Excel.

jpf1281
Newbie
Posts: 15
Joined: Mon Jun 14, 2021 1:40 pm

Re: Specific text to excel

Post by jpf1281 » Wed Jan 15, 2025 2:19 pm

Great thanks! I will give this a shot.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts