The import option ("Import Text..." under the "Utilities" menu of the Address Stack) was initially designed to handle addresses in the following format:
Name
Company
Street
City, State Zip
In order to handle international addresses ending in country names, or any other non-standard address ending in text, a line of script was inserted to evaluate whether the last word in the field was text or a number:
If Value(lastword) is a number then
This function works if the last word of the address field is all text, all number, or a valid mathematical expression, such as a ZIP-plus-four (96453-2345 for example). However, when a non-standard entry such as "USA+CANADA" is the last word in the field, the HyperCard VALUE function fails because it tries to evaluate the expression mathematically.
To fix the problem, run the import script. If HyperCard is set to userlevel 5, a dialog box with the choice of DEBUG, SCRIPT or CANCEL will appear if the script fails. Choose SCRIPT.
To fix the script for operation under HyperCard 2.1 replace the following
line:
if offset(lastWord, "/-+") = 0 then
with the line:
if offset("/",lastWord) = 0 and offset("+",lastWord) = 0 and
offset("*",lastWord) = 0 then
This fix should allow the import script to proceed to completion, though it will not place ZIP codes containing the +4 numbers into the ZIP code field.
The following line is intended to evaluate whether the last word of the address field is or is not a number :
if value(lastword) is not a number then
This article is adapted from the Claris Tech Info database.
Support Information Services