February 25, 200322 yr 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, "
February 25, 200322 yr 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" ?
February 25, 200322 yr As per your code above, It works fine IF the TextChunk and Email fields contain the same data (as posted by you)
February 25, 200322 yr 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
March 5, 200322 yr Newbies 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.
March 5, 200322 yr 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
March 20, 200322 yr Author 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..
Create an account or sign in to comment