How to sort record type code within the same policy ?

mohammad amir ashraff · New User Joined: 08 Feb 2008 Posts: 23 Location: Hyderabad

This is the current state of records in the file:

Anuj Dhawan · Posted: Mon Apr 07, 2014 4:47 pm

I'm not sure if I've missed something to follow the output from input, but is not it a simple case of sorting data on 3rd filed and then on 1st?

Nic Clouston · Posted: Mon Apr 07, 2014 4:48 pm

What have you tried? What was wrong with that? It looks as though you want to sort on columns 1 & 2 within columns wherever YHB0004xxx are. Is that the case? If so , your major sort key is the column where YHB starts for 10 bytes and your minor key is column1 for 2 bytes. Unless there is something that you have not told us?

mohammad amir ashraff · New User Joined: 08 Feb 2008 Posts: 23 Location: Hyderabad

Thank you Anuj, your option worked.

Anuj Dhawan · Posted: Mon Apr 07, 2014 5:15 pm

Thanks for the feedback - as they say, even a blind squirrel finds an acorn once in a while.

Nic had the same suggestion too but a timestamp error occurred in between, looks like...

Nic Clouston · Posted: Mon Apr 07, 2014 8:39 pm

Anuj, Nope - I was just more verbose. Your post was not there when I started but was there when I finished.