Hi Emma,
On May 22, 2008, at 5:33 AM, Emma Glaisher wrote:
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.
What version of Filemaker? 8.5 and above have the GetNthRecord
function which would handle this nicely.
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
Case (
Left(GetNthRecord ( Product ; Get ( RecordNumber ) ) ; 1) ≠ Left
(GetNthRecord ( Product ; Get ( RecordNumber ) - 1 ) ; 1 ) ;
"<Heading>¶" & "<B>" & Product & "<B> " & PageNum & "¶";
"<B>" & Product & "<B> " & PageNum & "¶"
)
HTH
--
Steve Moore
Cumberland, Maine
