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 !