Hi, May I please ask again. If I have groups of records: each group starts with one record of the header followed by one to many records of details. I would like the order of records within the group does NOT change, but all groups will be ordered by the header value, so the groups with the same headers will be together. If the header is the same - it doesn't matter which group comes first, but the details records inside the group of each header will not be changed.
Thanking in advance,
Input:
---------
header A2
data1
data2
data3
header A3
data4
data5
header A1
data6
data7
header A3
data8
header A2
data9
( the headers start with the constant 'header' and it is sorted by the pos 8-9 in the header )
Output:
---------
header A1
data6
data7
Header A2
data1
data2
data3
header A2
data9
header A3
data4
data5
header A3
data8
Irene