🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.sys.mac.databases
1 messages
1 total messages Started by Fred Puhan Sat, 05 Sep 1992 05:58
FileMaker Pro Question
#271
Author: 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.
                                       |
/= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=\
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads