Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sort by zip code 1
- Thread starter claudeb
- Start date
-
1
- #2
Hi,
If I understand it right, you have two separate records each time and you want to sort the file on information on the second record.
What you can do is read two recors at once in an inputprocedure of a sort. You fill a sortrecord with a prefix with the zipcode and a serialnumber followed by the contents of the original record. On the outputprocedure you can strip off that prefix and write the original record back in the new order you created by this action.
Let us know if this does help you.
If I understand it right, you have two separate records each time and you want to sort the file on information on the second record.
What you can do is read two recors at once in an inputprocedure of a sort. You fill a sortrecord with a prefix with the zipcode and a serialnumber followed by the contents of the original record. On the outputprocedure you can strip off that prefix and write the original record back in the new order you created by this action.
Let us know if this does help you.
- Thread starter
- #3
Using syncsort you can sort this at once giving the position of your sortfields. It depends on if your data is on the same place in every record.
Something like
sort fields=(20,6,,a)
which says something like starting from position 20 over a length of 6 no conversion ascending. But look the exact parm up in the manual or copy some existing example.
Does this help you?
Something like
sort fields=(20,6,,a)
which says something like starting from position 20 over a length of 6 no conversion ascending. But look the exact parm up in the manual or copy some existing example.
Does this help you?
- Status