RE QUIZ 'PACK' command

Kirk, Dean Dean.Kirk@COGNOS.com
Wed, 9 Aug 2000 09:31:06 -0400


Adding to the many that will appear :

DEF D_LINE char*100 = TRUNC(PACK(CITY + " " + PROVINCE_STATE)) + "  "  +
POSTAL_ZIP_CODE

Dean Kirk
Cognos Ltd

-----Original Message-----
From: Bob Feighner [mailto:bfeighnr@mailclerk.ecok.edu]
Sent: 09 August 2000 15:13
To: powerh-l@sphere.swau.edu
Subject: QUIZ 'PACK' command


Greetings Gurus,

My question is simple, but the solution isn't (to me). I'm trying to format
address labels exactly as prescribed by the US postal service. Specifically,
the
last line should look like this:
CITY ST  12345-6789

Our files are set up so that city, state, and zip are three separate fields,
so
this should be a simple use of the PACK command. Well, I want TWO spaces
between
city state and zip code. I've tried various ways to fool the PACK command,
but
it continues to place one space between these fields. 

Any ideas on forcing two blank spaces? Thanks.

Bob Feighner
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.