Gary,
Thanks for sharing your solution and the side effect that I'll need to change the
letter address as well. My respect for ebase, FileMaker and the user community is
rising rapidly.
When I examined where to make the change suggested by Jack Noll, I discovered that
there are 5 ebase label layouts. Only one would seem to be needed to print labels.
This has become an interesting FileMaker learning experience.
With courage, caution, study, and backup copies, I expect to get one of these
solutions installed in our copy of ebase.
Thanks,
John
Eastern Trail Alliance
At 09:50 AM 7/30/2001 -0400, you wrote:
>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
>---------------------------------------------------------------------
>
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
---------------------------------------------------------------------
