|
View previous topic :: View next topic
|
| Author |
Message |
karz
New User
Joined: 04 Feb 2010
Posts: 39
Location: Mumbai
|
|
|
|
Hi,
I have the alphanumeric field with numeric data and 2 decimal points along with leading sign. I just need the total of this field in SYSOUT. No need of any key or sorting.
I/P
+0000000000000164.00
+0000000000000001.00
+0000000000000002.00
O/P
+0000000000000166.00
Could anyone help with the sort card for this. I tried searching in forum but all had sort on key which i donot want. |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Just use OPTION COPY or SORT FIELDS=NONE in place of the SORT. |
|
| Back to top |
|
|
karz
New User
Joined: 04 Feb 2010
Posts: 39
Location: Mumbai
|
|
|
|
| Yes, but what will be the sortcard to change the alphanumeric to numeric and then put the total in sysout. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Well, I was thinking if you'd found something with what you want but it had a SORT, then the advice may get you going with it.
Have a look at data-type SFF, and OUTFIL reporting functions, REMOVECC, NODETAIL, TRAILER1 with TOT/TOTAL and EDIT=. |
|
| Back to top |
|
|
|
|
