Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
It's not clear what you want to do. You say the total is 55 bytes but 24+11+24 adds up to 59 bytes, not 55 bytes. You say you want to sort on the first name, middle name and last name. The result of sorting that way with
| Code: |
SORT FIELDS=(1,59,CH,A)
|
or with
| Code: |
SORT FIELDS=(1,24,CH,A,25,11,CH,A,36,24,CH,A)
|
which are equivalent, would be:
| Code: |
chandan0 kumar1
chandan0 kumar1 mehta1
chandan0 kumar12 mehta11
chandan0 kumar23 mehta12
|
since blank sorts before the letters, but you show the expected result as:
| Code: |
chandan0 kumar1 mehta1
chandan0 kumar12 mehta11
chandan0 kumar23 mehta12
chandan0 kumar1
|
You need to explain more clearly what you're trying to do and the "rules" you want to use to get the result you want. |
|
