Parsing emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to parse the name out of form submitted via email. I can
read the email as one string, but I'm having difficulty dealing with the
variable length of names and the space in between the first and last name.
For example:

Name: Todd Thompson

The position of "Name: " is fixed, however the charlen is variable.

Any ideas?

Thanks,

Todd
 
You can use some string commands to parse the string.

InStr() and Mid() are very helpful. You can use InStr to find the first
space character in your string, and then use the Mid to parse out the first
name and another Mid statement to parasee out the last name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top