|
View previous topic :: View next topic
|
| Author |
Message |
Aneesh
New User
Joined: 30 Sep 2006
Posts: 60
|
|
|
|
Hi,
I have a file(FB LRECL 280) that has a data field that is in the edited picture format PIC +9(06).9(03) in positions 132-142.
File layout
Item 8-12
Qty 132-142
Is there a data format that can be used to sort the qty field directly in the numeric order?
Sample date (132-142)
+000000.000
+000015.000
-000002.000
+000000.000
+000005.000
Thanks,
Aneesh. |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Yes, assuming the sign is always +, you can use DFSORT's UFF format. For example:
| Code: |
SORT FIELDS=(132,11,UFF,A)
|
If the sign could be + or -, you could use DFSORT's SFF format. |
|
| Back to top |
|
|
Aneesh
New User
Joined: 30 Sep 2006
Posts: 60
|
|
|
|
| Thanks a lot, Frank. |
|
| Back to top |
|
|
|
|
