Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Parsing emails - Argh!

Featured Replies

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, "

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" ?

As per your code above,

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

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 smirk.gif

Parser.fp5.zip

  • 2 weeks later...
  • 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.

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 smile.gif

  • 2 weeks later...
  • 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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.