John,
We ran into this same problem at the Landmark Society, using ebase version
1.00. I discovered that a calculation field named PARSE: PREDIRECTIONAL 2
was looking for compass names and changing them into letters using the
formula:
Case(
PARSE: PREDIRECTIONAL = "North", "N",
PARSE: PREDIRECTIONAL = "South", "S",
PARSE: PREDIRECTIONAL = "East", "E",
PARSE: PREDIRECTIONAL = "West", "W",
PARSE: PREDIRECTIONAL
)
This was not good, as Rochester has Avenues with all these names. Also, many
of our most generous contributors live on East Avenue, a grand boulevard,
and take it as a point of pride. So I modified the formula by adding an
additional Case option, before the others:
Case(
PatternCount( ADDRESS\DELIVERY, "~") > 0,
PARSE: PREDIRECTIONAL,
PARSE: PREDIRECTIONAL = "North", "N",
PARSE: PREDIRECTIONAL = "South", "S",
PARSE: PREDIRECTIONAL = "East", "E",
PARSE: PREDIRECTIONAL = "West", "W",
PARSE: PREDIRECTIONAL
)
This tells the calculation to not make any changes if it sees a tilde (~)
character (it's to the left of the number 1 on the keyboard). Our data-entry
person simply types a tilde before any street name she wants to NOT be
modified, i.e. 200 ~West Avenue. Then I also needed to modify the ADDRESS
LINE\LETTER field, adding the Substitute function to strip out the tildes
before printing:
If(IsEmpty(ADDRESS\SUPPLEMENTARY),"",ADDRESS\SUPPLEMENTARY & "???") &
Substitute ( ADDRESS\DELIVERY, "~", "")
...where ??? represents the Paragraph (Return) character.
This scheme has worked well for two years.
Gary
> Subject: Abbreviations - Help needed
> From: John Andrews <[EMAIL PROTECTED]>
> Date: Thu, 26 Jul 2001 09:01:03 -0400
> X-Message-Number: 2
>
> Greetings,
>
> I'm a new user with lots of progress, but I'm stuck on an automated
> abbreviation problem.
>
> When the words East or West appear in an address, ebase automatically
> changes them to E and W.
>
> One of our members lives on West Street. The ebase label reads W ST. I
> tried quotes, but the quotes are printed.
>
> Has anyone overcome this quirk?
>
> John Andrews
> Eastern Trail Alliance
> Southern Maine Coast
>
> John Andrews
> P.O. Box 852
> Saco, Maine 04072
>
> www.EasternTrail.Org
> www.SacoBayTrails.Org
> 207-282-1979
>
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
