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)