Definition to delimited question
Whittall, Conrad
Conrad.Whittall@Cognos.COM
Wed, 13 Dec 2000 16:02:11 -0500
Could it be that the fact you've defined your separator character as CHAR*6
that is causing those five extra characters to appear? PowerHouse will
always pad with spaces if the value assigned is shorter than the target. Try
DEFINE SEPC Character*1 = ";" instead, and see what happens.
Best regards,
Conrad
Conrad Whittall
Marketing Manager, Application Development Tools, Cognos Incorporated
Developer productivity never goes out of style!
For details of the Cognos PowerHouse family of high-productivity
development tools for Web, Windows and terminal-based business
applications just look here, http://www.cognos.com/powerhouse.
-----Original Message-----
From: Bob Bushley (Burbank) [mailto:BBushley@burbank.haskel.com]
Sent: Wednesday 13 December 2000 15:57
To: powerh-l@lists. swau. edu (E-mail)
Subject: Defination to delimited question
I and outputing to a portable subfile
SET SUBFILE NAME CYCLEBASETXT NODICT PORTABLE KEEP
SET REPORT SPACING 0
my elements define example is
DEFINE EDUS CHAR*10 = "" ;* 1. EDI - User ID
String 10
DEFINE EDBT CHAR*15 = "" ;* 2. EDI - Batch Number
String 15
DEFINE EDTN CHAR*22 = "" ;* 3. EDI - Transaction
Number String 22
DEFINE EDLN CHAR*7 = "" ;* 4. EDI - Line Number
Number 7,7[3]
DEFINE EDCT CHAR*2 = "" ; 5. EDI - Document Type
String 2
DEFINE TYTN CHAR*8 = "JDECYCLE" ; 6. Type - Transaction
String 8
DEFINE EDFT CHAR*10 = "" ; 7. EDI - Translation
Format String 10
DEFINE EDDT CHAR*6 = "" ; 8. EDI - Transmission Date
Date 6
DEFINE DRIN CHAR*1 = "1" ; 9. Direction Indicator
Characte 1
DEFINE SEPC Character*6 = ";"
REPORT sum TAB 1 &
EDUS &
SEPC &
EDBT &
SEPC &
EDTN &
SEPC &
EDLN &
SEPC &
EDCT &
SEPC &
TYTN &
SEPC &
EDFT &
SEPC &
EDDT &
SEPC &
DRIN
I am creating a data conversion file, my output looks like
; ; ; ;
; JDECYCLE; ; ; 1
except for the 1st field all the rest have an extra 5 characters. WHY? How
do I get rid of these characters or must I tab every element?
I have 45 elements in this conversion file. I have appx. 15 conversion files
tabbing would be a nitemare. AND I have more files to create!
Thank You!
Bob Bushley
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.