Gareth Horton
July 12th, 2002, 02:52 PM
Thanks for your suggestions, but unfortunately we do not currently have Monarch V6. However, I did eventually extract all the address data separately without too much difficulty. I grabbed the lines, and luckily the line after the address ends is always blank. So if the final field was blank then I knew that it was a 3 line address, if not blank then I knew it was a 4 line address. Using this knowledge I just created calculated fields to extract the information that I wanted for each addy.
Thanks again for your help!
> Brian,
>
> You are correct, the Zip trap will not work properly without the justification.
>
> There may be a way to successfully extract all the address information, however.
>
> If you are able to trap the first line of the address somehow, then you can use the Monarch 6
> Address Block feature to correctly parse out the addresses.
>
> 1. Create a trap that grabs the first line of each address.
>
> 2. Highlight the field and doubleclick to get the Advanced field options.
>
> 3. Use the "End Field On - Blank Field Values" 1 option
>
> 4. This should now highlight the whole address for each record
>
> 5. Go into the table and choose the Address Blocks icon
>
> 6. Go through the steps to pull out the block into separate fields
>
> This does require the ability to be able to trap the first or perhaps second line of the address.
>
> If you use the second or a consecutive line, then just create a multiline trap and trap on line 2, pull in the first field as a normal field and follow the steps above for the field on line 2.
>
> Gareth Horton
> Datawatch
Thanks again for your help!
> Brian,
>
> You are correct, the Zip trap will not work properly without the justification.
>
> There may be a way to successfully extract all the address information, however.
>
> If you are able to trap the first line of the address somehow, then you can use the Monarch 6
> Address Block feature to correctly parse out the addresses.
>
> 1. Create a trap that grabs the first line of each address.
>
> 2. Highlight the field and doubleclick to get the Advanced field options.
>
> 3. Use the "End Field On - Blank Field Values" 1 option
>
> 4. This should now highlight the whole address for each record
>
> 5. Go into the table and choose the Address Blocks icon
>
> 6. Go through the steps to pull out the block into separate fields
>
> This does require the ability to be able to trap the first or perhaps second line of the address.
>
> If you use the second or a consecutive line, then just create a multiline trap and trap on line 2, pull in the first field as a normal field and follow the steps above for the field on line 2.
>
> Gareth Horton
> Datawatch