Forum Discussion
Breakdown data in cell column
Hello,
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<https://-sljal.formstack.com/forms/floxgen__review_form>
Submitted at 01/12/23 8:16 PM
Date/Time: Jan 12, 2023 08:14:33 PM
VenueId: 145
VenueName:
VendorId: XXXX
VendorName: XXX
SeatId: XXXXX
TableNumber: XXXX
SeatNumber: X
OrderId: XXXXXXXXXXXXXXX
RatingSubmissionId:
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
Name:
Phone:
Email:
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?