Day 10 Challenge Resources

The marketer at the SAAS company received a list of attendees from the event organizer for a recent networking event. However, the list had some random characters such as “#” or “@” appended to all values in the first name column. In order to send a quick follow-up, the marketer has been tasked with eliminating these random characters when sending the email.

If you’d like to test your code, feel free to use the sample data available here.

Download CSV
Email FirstName LastName
john.doe@gmail.com #John Doe
jane.doe@yahoo.com @Jane Doe
mark.smith@hotmail.com @Mark Smith
sara.johnson@outlook.com #Sara Johnson
adam.wilson@gmail.com #Adam Wilson

If you used one of the examples I provided, you might end up with an email that looks something like this. Keep up the good work!

Hello Lisa,

Thank you for attending our recent networking event. We hope you enjoyed the opportunity to connect with others in the industry and learn more about our SAAS product.

As a follow-up, we would like to offer you a free trial of our SAAS product. Simply reply to this email, and we will set up your account.

Thank you again for your participation in our event, and we hope to hear from you soon.

Best regards,
The SAAS Company 

Crafted with 💜 by AMPscript30.
AMPScripted Smiles Ltd.
456 Data Extension Drive Suite 321, Loop City, 
Variable Valley, DE 12345

Boost AMPscript Skills in Just 30 Days!

Whether you're just starting with AMPscript coding or looking to expand your skills, this challenge is for you!

[yikes-mailchimp form="1"]