Page 1 of 1

Sort problem

PostPosted: Tue Feb 09, 2010 8:04 pm
by mindhawk
Hi

I am trying to run a comparison between 2 files.
Read in both and the match on an account ID.
If file A acct id < file B acct id . read file A
and reverse for file B

my problem is that on one file I have file A acct ABRAHAM168
other file B acct is ABRAHA1070

The hex for the first 6 chars are the same but the hex for the last 4 are higher on file B (f1 f0 f7 f0) as opposed to D4 F1 F6 F8
File B does have the account ID I am looking for on File A (ABRAHAM168) but it is after ABRAHA1070.

How can I sort file A so to match the sort in file B ?
I dont want to sort FILE B as its 200Gig split into 65 files.

Any assistance appreciated !

Re: Sort problem

PostPosted: Tue Feb 09, 2010 10:16 pm
by Frank Yaeger
Your description is very confusing.

CH format (EBCDIC) sorts the letters before the numbers.

AC format (ASCII) sorts the numbers before the letters.

You just have to be sure that both files are sorted using the same format.

If you want more specific help, show an example of the records in each input file so I can see how they are ordered.