Thus spake Dana Smith <[EMAIL PROTECTED]>:
> I have a field that contains names of items that start with either Photo,
> Fig, Unfig, or Car and want to copy those name beginnings (either 3 or 5
> letters) to another field so the data can be concatenated into a calculation
> field that combines the text Photo, Fig, Unfig, or Car
This will do it. It's not elegant, but if you want elegant, ask someone on a
FileMaker Pro list. :->
This assumes you have a field named "FigUnfig" with exactly two things that
can be abbreviated with three letters, "Car" and "Fig." Set up another field
that is a calculation field and enter this as the formula.
If(Left(FigUnfig, 3) = "Car", "Car", If(Left(FigUnfig, 3) = "Fig", "Fig",
Left(FigUnfig, 5)))
The result will be either "Car," "Fig," or the first five letters of
anything else, like "Photographs."
peter
--
Help the environment! Become a vegetarian! <http://www.vegpledge.com/>
--
To unsubscribe:
<mailto:[EMAIL PROTECTED]>
archives:
<http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/>
old-archive:
<http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
