sort unique records
Posted: Fri Nov 12, 2010 1:52 am
My input file is something like below,
334219 40878002733100420100723A00000046218MOR
334219 42947178433100420100723A00000071316GOR
444219 42947178433100420100723F00000035658GOR
444219 43331199733100420100723A00000027897GOR
555219 47572143533100420100723A00000066664GOR
555219 21472494133100620100723A00000002760GOR
First 6 byte is plan number. I want to filter only unique records based on plan number. The output would be something like,
334219 42947178433100420100723A00000071316GOR
444219 42947178433100420100723F00000035658GOR
555219 47572143533100420100723A00000066664GOR
Is it possible using SORT?
334219 40878002733100420100723A00000046218MOR
334219 42947178433100420100723A00000071316GOR
444219 42947178433100420100723F00000035658GOR
444219 43331199733100420100723A00000027897GOR
555219 47572143533100420100723A00000066664GOR
555219 21472494133100620100723A00000002760GOR
First 6 byte is plan number. I want to filter only unique records based on plan number. The output would be something like,
334219 42947178433100420100723A00000071316GOR
444219 42947178433100420100723F00000035658GOR
555219 47572143533100420100723A00000066664GOR
Is it possible using SORT?