[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

Parsing a text field into other fields

I need the information from the following text field imported from Outlook.  It's a response from a Web RSVP form.  It is in a consistant format.  I have put the quotes in.

I need the line after "Both Names Required"
I need the line after "Handicap"
I need the text after "I'd like to be in a team with..."
I need the text after "Address (needed for Donations)"

"You've just received a new submission to your RSVP Form <http://sasgolfday.weebly.com/entries-and-donations.html> .



Submitted Information:


No, but let me know how it goes

Email
dwrathborne@gmail.com

Both Names Required
Test Message

Handicap
100

I'd like to be in a team with...
Any bugger

Address (needed for donations)
My address
Addressville
Australia"
0
NoGurru
Asked:
NoGurru
1 Solution
 
als315Commented:
Try this sample (function get_txt in module1 and query1- example)
DBtext.mdb
0
 
NoGurruAuthor Commented:
Wow!  Just what I need!! Thank you!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now