FW: QUIZ 'PACK' command

[Kesterson, Roger]

try:

	truncate(city) + "  " + truncate(state) + "  " + truncate(zip)

> -----Original Message-----
> From: Bob Feighner [mailto:bfeighnr@mailclerk.ecok.edu]
> Sent: Wednesday, August 09, 2000 7:13 AM
> 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.