View previous topic :: View next topic
|
Author |
Message |
kris_madras Warnings : 1 New User
Joined: 04 Jul 2005 Posts: 31
|
|
|
|
Not sure why.. Sure I can get help here..
My work shop is using SYNCSORT. I am summarizing input file on Hour field to calculate frequency with header in the final output.
INREC FIELDS=(001:009,02, TX HOUR
010:C'00000001') RECORD COUNT
SORT FIELDS=(001,002,CH,A)
SUM FIELDS=(010,008,ZD)
OUTFIL FNAMES=MOTHREPT,
HEADER1=('HOUR',' COUNT')
Final output looks good.. but the output is starting from Column 2, with character '1' in column1..?
Code: |
----+----1----+---
******************
1HOUR COUNT
118 00000185
19 00000131
20 00000216
21 00000141
22 00000112
23 00000083 |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You have defined a "report" and those are "carriage control" characters.
All is working as it should. When you print the report, you will have the proper output. The carriage control characters do not actually print on the page. |
|
Back to top |
|
|
kris_madras Warnings : 1 New User
Joined: 04 Jul 2005 Posts: 31
|
|
|
|
dick scherrer wrote: |
Hello,
You have defined a "report" and those are "carriage control" characters.
All is working as it should. When you print the report, you will have the proper output. The carriage control characters do not actually print on the page. |
Great!.. Thanks for your quick reply.. need another help .. Can we suppress leading zeroes in the SUM FIELDS output as shown above? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Yes, you can use the EDIT subparameter of OUTREC. Modify this to fit what you need:
Code: |
OUTREC FIELDS=(1,50,64,4,PD,M2,68,6,ZD,
EDIT=($I,IIT.TTS),SIGNS=(,,+,-)) |
This example uses one packed decimal field and a "standard" edit mask and one zoned decimal field with a user-defined edit mask. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
kris_madras wrote: |
...the output is starting from Column 2, with character '1' in column1..? |
Quote: |
You have defined a "report" and those are "carriage control" characters. All is working as it should. When you print the report, you will have the proper output. The carriage control characters do not actually print on the page. |
Please also refer to the optional REMOVECC parameter. If the output is intended to be viewed online or written to a list data set rather than a printout, then this option may be what you are looking for. |
|
Back to top |
|
|
kris_madras Warnings : 1 New User
Joined: 04 Jul 2005 Posts: 31
|
|
|
|
Thanks so much for your replies and suggestions |
|
Back to top |
|
|
|