🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #271

FileMaker Pro Question

#271
From: Fred Puhan
Date: Sat, 05 Sep 1992 05:58
31 lines
1784 bytes
Here's an interesting (to me) problem: I would like to take name, address, and 
telephone number fields from within a FileMaker Pro database and create
"telephone book"-style fields; i.e., given the following example:

           name:  SampleName
        address:  SampleAddress
 city,State Zip:  Anytown, XX  NNNNN
          phone:  NNN-NNNN

I need to concatenate the name and address fields, add dot-leaders, then the
telephone number to yield:

      formatted:  SampleName SampleAddress........................NNN-NNNN

The question I have is how to calculate (and then fill) the number of periods
needed to "pad" the space between the listing data and the phone number. I
have no trouble calculating the length of the formatted name/address, and even
using a "fixed-length" for the formatted listing, am still not able to dynami-
cally perform a "repeat for" function to pad the dots. Any suggestions?

/= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=\
                                       |
Fred Puhan                             |  1.  Outside of a dog, a book is man's
PRC Inc.                               |      best friend.
                                       | 
fred.puhan@f70.n109.z1.fidonet.org     |  2.  Inside of a dog, it's too dark to
puhan.fred@po.gis.prc.com              |      read.
                                       |
/= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=\
Technical Details
Message-ID: <715719654.F00001@blkcat.UUCP>
Path: arc1-ca.pugleaf.net!sparky!uunet!blkcat!Uucp

Show Full Headers
Complete Article Headers
From: Fred.Puhan@p4219.f70.n109.z1.fidonet.org (Fred Puhan)
Sender: Uucp@blkcat.UUCP
Path: arc1-ca.pugleaf.net!sparky!uunet!blkcat!Uucp
Newsgroups: comp.sys.mac.databases
Subject: FileMaker Pro Question
Message-ID: <715719654.F00001@blkcat.UUCP>
Date: Sat, 05 Sep 1992 00:58:09 -0500
Lines: 32