Gareth Horton
July 12th, 2002, 02:30 PM
Hi,
The purpose for the Postal trap is to capture address data of varying lengths. This Trap works by recognizing the zip (or Postal Code), reading backwards and up (left justified) until it reaches a blank line.
You have two choices to extract the data sample you provided.
1. Create a Detail Template using the End Field On options to pick up the contact (phone, fax, email) data as a Memo field. This would work provided there is a phone number for every entry to trap on. This way you would just need to parse the contact data using calculated fields. Then create an Append Template for the address data using the Postal Trap.
or
2. Extract the entire block as a Memo field using the End Field On options and parse the data using calculated fields.
Unfortunatly, when address blocks of varying lines (and may contain other data such as the phone, etc)are formatted in a report without labels:
Name:
Title:
Address 1:
Address 2:
City, State, zip:
Phone:
Fax:
Email:
it requires some work to extract the data properly.
I hope this has been helpful.
Dee Moore
Datawatch Corporation
Technical Support & Model Building
978.441.2200
For new issues please use our Technical Support Form at:
http://www.datawatch.com/forms/dsp_tech_support.asp
This will insure your issues are routed properly and
responded to in a timely manner.
For Model Building, please visit:
http://www.datawatch.com/services/model-building.asp
Gary Sunada wrote:
> Hello -- is there a way to expand the postal trap to include capturing the phone number, fax number and e-mail address of the following example:
>
> Dr. Joe Smith
> Technical Director
> Research Unlimited, Inc.
> Mail Stop 253-4
> 89 Research Road
> Metro City, NY 13440
> (213)555-1234
> fax:(213)555-1235
> joe.smith@researchunlimited.com
>
> The postal trap can only catch the first six lines and ignores the last three. Or perhaps there's a method to capture all lines (which vary from six to ten lines) by using the line spaces in between addresses? There appear to be no straightforward features in the address (except for the city, state, zip -- there may or may not be phone numbers, fax #s, or e-mail) by which to capture the address block. Any suggestions?
>
> Thanks,
> Gary Sunada
>
[ May 02, 2006, 05:56 PM: Message edited by: Todd Niemi ]
The purpose for the Postal trap is to capture address data of varying lengths. This Trap works by recognizing the zip (or Postal Code), reading backwards and up (left justified) until it reaches a blank line.
You have two choices to extract the data sample you provided.
1. Create a Detail Template using the End Field On options to pick up the contact (phone, fax, email) data as a Memo field. This would work provided there is a phone number for every entry to trap on. This way you would just need to parse the contact data using calculated fields. Then create an Append Template for the address data using the Postal Trap.
or
2. Extract the entire block as a Memo field using the End Field On options and parse the data using calculated fields.
Unfortunatly, when address blocks of varying lines (and may contain other data such as the phone, etc)are formatted in a report without labels:
Name:
Title:
Address 1:
Address 2:
City, State, zip:
Phone:
Fax:
Email:
it requires some work to extract the data properly.
I hope this has been helpful.
Dee Moore
Datawatch Corporation
Technical Support & Model Building
978.441.2200
For new issues please use our Technical Support Form at:
http://www.datawatch.com/forms/dsp_tech_support.asp
This will insure your issues are routed properly and
responded to in a timely manner.
For Model Building, please visit:
http://www.datawatch.com/services/model-building.asp
Gary Sunada wrote:
> Hello -- is there a way to expand the postal trap to include capturing the phone number, fax number and e-mail address of the following example:
>
> Dr. Joe Smith
> Technical Director
> Research Unlimited, Inc.
> Mail Stop 253-4
> 89 Research Road
> Metro City, NY 13440
> (213)555-1234
> fax:(213)555-1235
> joe.smith@researchunlimited.com
>
> The postal trap can only catch the first six lines and ignores the last three. Or perhaps there's a method to capture all lines (which vary from six to ten lines) by using the line spaces in between addresses? There appear to be no straightforward features in the address (except for the city, state, zip -- there may or may not be phone numbers, fax #s, or e-mail) by which to capture the address block. Any suggestions?
>
> Thanks,
> Gary Sunada
>
[ May 02, 2006, 05:56 PM: Message edited by: Todd Niemi ]