Removing trailing spaces from delimited files...

[Mike Palandri]

DO you want to remove trailing spaces from individual report items, or from the end of the reported record.  If it's the former, you can convert each item to character, then truncate and concatentate them into a single large item.  This is off the top, and untested:

ACCESS SOMEFILE

DEF DC-BIG-EL	CHAR*100 =  &
TRUNC(CHAR-ITEM1) + ";" + &
TRUNC(CHAR-ITEM2) + ";" + &
TRUNC(FORMATNUMBER(NUM-ITEM3, " #####,###","-#####,###")) + ";" + &
TRUNC(CHAR-ITEM4)

REPORT DC-BIG-EL


At 09:33 AM 11/20/2000 -0600, Edis, Bob wrote:
>G'day Chris
>
>The only way I have been able to do this in the past was to make the output
>as a subfile NODICT.  Convert any non-alpha to alpha items first.
>
>Blue
>
>-----Original Message-----
>From: Gassett, Chris [mailto:Gassett@aavid.com]
>Sent: Monday, November 20, 2000 9:05 AM
>To: Powerhouse Users List (E-mail)
>Subject: Removing trailing spaces from delimited files...
>
>
>Anyone now how to remove the trailing spaces from variable width data when
>outputing to a delimited text file with Quiz?
>
>This example is what I am after:
>
>LAMR123123;TEST DATA DESCRIPTION;100.32;--A;M
>MN234234;WELDER,GREEN,200AMP;2310.23;--B;M
>
>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>

Mike