I often use Filemaker to prepare text to be imported into QuarkXPress. I have calculation fields that add formatting tags to the text.
However, sometimes I want to put something in depending on the content of a field compared to the field in the previous record. For instance, if the Fields Product¹ and Page No¹ have the following values: Aardvarks 22 Apes 25 Apples 33 Balloons 27 Boxes 38 Suppose I have a calculation field which is putting bold¹ tags around the Product, and then adding the Page No, so it will look something like: <B>Aardvarks<B> 22 <B>Apes<B> 25 etc Now, I want the Balloons calculation to say Aha, the first letter of Balloons is not the same as the first letter of Apples (the previous record). I will need a heading to announce that there is a new letter, so I shall also add into my calculation field: <Heading>B<end Heading>return <B>Balloons<B> 27 And I can¹t see how to do it! At least, I can do it in a script as it can set a variable to the first character of a record and then compare it when it gets to the next record. This works well, but means that a script has to run. I¹d like it to be part of the calculation, which I¹m not sure is possible! At present I use a very useful tool in Quark which, combined with my formatted Filemaker text, does this for me. But if I can make Filemaker do that, my solution can be used without the need to buy an extra piece of software. Thanks Emma - - Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law.
