RegEx for Extracting/Harvesting Data From Source Text

regex

#1

EDIT: I've worked on it and can get everything except the
city
state
zip
phone
I'll post the macro once I get the rest. - cheers.

First - thank YOU to all that have helped me on the previous regex solutions.
@ccstone @gglick @Rather
I have learned a lot and have been able to modify the example actions that were shared with me to achieve other things. But I have not been able to extract all that is needed efficiently from the example text at the end of this post. Which is from another site. The client would be the first listed client, Melissa Thomson, which will always be below the text "Newest - Oldest"

I'd like to harvest the following variables from the example text:
%Variable%HA_Name_Full%
%Variable%HA_Name_First%
%Variable%HA_Name_Last%
%Variable%HA_Phone_Daytime%
%Variable%HA_Client_Email%
%Variable%HA_Client_Address_Street%
%Variable%HA_Client_City%
%Variable%HA_Client_Zip%
%Variable%HA_Client_Comments%

Example text follows and also attached as .txt file

logoAngiesList.comHELPMUFFETTA
A
207 Reviews
Muffetta's Westchester & White Plains House Cleani SPID: 2337098
66 E Post Rd, White Plains, New York, 10601
Home
Leads
1
Messages
Reviews
Profile
Leads for Muffetta's Westchester & White Plains House Cleani
 66 E Post Rd White Plains, NY 10601
 Need the old jobs page? It's here >
Showing 1 - 10 of 44 results
Sort by
Newest - Oldest
Melissa Thomas
House Cleaning
Quote Request
01/02/19
Lead status

1234 Seward Ave
Bronx, New York 10473

(917) 123-4567

melissathomas_123456b@yahoo.com

Send Message

Request a Review
Customer Notes
Basement apartment need help with kitchen living room and bathroom.

Your Notes
Add Notes
Alyssa Luc
House Cleaning
Quote Request
01/06/19
Lead status

Summer Bhullar
House Cleaning
Quote Request
01/02/19
Lead status

Kevin Murphy
House Cleaning
Quote Request
12/22/18
Lead status

Raja Chris
House Cleaning
Quote Request
11/19/18
Lead status

Ryan Cola
House Cleaning
Quote Request
11/18/18
Lead status

Erik Malvarez
House Cleaning
Quote Request
11/18/18
Lead status

daniel martin
House Cleaning
Quote Request
11/14/18
Lead status

Jennifer Davis
House Cleaning
Quote Request
11/11/18
Lead status

Leandro Lombardia
House Cleaning
Quote Request
11/10/18
Lead status

Prev
12345
Next
Does the information on this page help you manage your Angie's List leads more effectively?

Yes
No
Comment
Send Feedback
Download the Free Angie’s List Pro App
BUSINESS CENTER

Profiles
Manage My Account
Contact Preferences
Add A Business
BUSINESS APPS

iOS App
Android App
ABOUT US

AngiesList.com
Online Offers
Expert Content
QUESTIONS

Contact Us
Press Center
Investor Relations
Connect with us

1 (866) 843-5478
Nationwide TDD/TTY: Call 711

Give us a call.
We're standing by.

Angie's List Call Center

M-F: 8:15am - 8:15pm EST
Drop us a line

Email us and we'll reply as quickly as possible.
logo
© Copyright 1995-2019, Angie's List. All Rights Reserved. | Terms of Use | Privacy Policy | Service Provider Agreement

Example Text.rtf.zip (2.0 KB)


#2

Hey @troy,

Here's an example.

I've done something a bit different than the last time in that I've extracted the main data from the data source in the first action.

This way additional searching avoids interaction with unnecessary cruft.

-Chris


Regex – Harvest Variables From Multi Line Text -- HA Version -- v1.00.kmmacros (12 KB)