Parsing emails - Argh!

[Scythe000]

Hi, all! Okay, I looked over the other article about parsing emails, and it was really helpfull, but I can't seem to get it to work. I believe I'm following his directions, but everytime I run my script, my field (for example "city") stays blank. Here is the contents of the email I'm trying to parse:

Form from: http://travelagentdeals.com/pages/Subscribe.html

Filled out by: 207.178.226.62

Email created by:

Follow up: http://www.travelagentdeals.com/pages/thank_you.html

------------------------------------------------------------

Fax+Number: 234-235-2341

Zip+Code: 123456

Business+Profile: only Commercial

SMTP+Server: mail.iswest.com

Name: john bigboote

Done: Submit Query

ARC%2FIATAN+Number:

Specialize+in:

Debug: OFF

Consortium:

Website:

City: drhesrhe

Computer+Type: HTML capable

Phone+Number: 234-235-2341

Agency:

Additional+Email+12:

State%2FProvince: ca

Additional+Email+22:

Email: [email protected]

Additional+Email+32:

Agency+Address+1:

Okay, and here is a snippet of my script, which should display the value of the city in the current email, which I'm pulling in using pop3it:

Set Field ["city", "Middle(TextChunk, Position( Email, "

[BobWeaver]

Not sure which other article you are refering to, but the formula you posted won't do this by itself. It looks like you may have missed something. What exactly is "TextChunk" ?

[andygaunt]

As per your code above,

It works fine IF the TextChunk and Email fields contain the same data (as posted by you)

[djgogi]

Didn't check your script but I've attached the file with an alternative way to script it.

(It works with data you have supplied)

Dj

Parser.fp5.zip

[SteveAtWork]

Hate to interject, but I am also searching for a solution to parsing email data into FMP - can someone post, or point me to, the full solution for this?

Thanks.

[Lee Smith]

Steven,

If your mail is separated like the example given by the original poster, then download the attachment offered above by DJ,

It works great.

If not, an example of your text file that you need to parse would help point you in the right direction.

Lee

[Scythe000]

Ugh, thanks, guys. I made a dumb mistake as was posted. I appreciate the advice. I would have responed sooner, but i seems that i'm no longer being notified of responses to my posts by e-mail...hhmmm..