Breakdown data in cell column

Copper Contributor



I have to filter through hundreds of emails a day. In trying to make it an easier process I have exported the emails pertaining to me into an excel spreadsheet. My issue is that I want to split the body of the email. 

(Email Body)

[Formstack Logo]
Formstack Submission For: Floxgen Overall Experience Review<>
Submitted at 01/12/23 8:16 PM
Date/Time: Jan 12, 2023 08:14:33 PM
VenueId: 145
VendorId: XXXX
VendorName: XXX
TableNumber: XXXX
SeatNumber: X
XXXXX:: [ XXX ] Newark Liberty Intl, Newark, NJ
Where:: Restaurant
Stars: X
How likely are you to recommend us to a friend or colleague?: X
Rate your Experience:: Food Quality = X
Ordering Process = X
Speed of Service = X
Staff Friendliness = X
Overall Ambiance = X
Cleanliness = X
Checkout Process = X
Would you like to share your name and contact information?: XX
We'd love to know more about your experience here:: xxxx xxxxxx xx xxxxxxxx

Copyright © 2023 Formstack, LLC. All rights reserved. This is a customer service email.

Formstack, 11671 Lantern Road, Suite 300, Fishers, IN 46038


The information I need from the body is (Date, Guest Name, Guest Email, Unit Name)


I there a way to make this process less painful?


0 Replies