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.