SORT-MERGE/XL General User's Guide (32650-90883)

72 Chapter6

SORT-MERGE/XL Commands

ALTSEQ

sp ! " # $ % & ' ( ) * + , - . /

0 1 2 3 4 5 6 7 8 9 : ; < = > ?

@ [ \ ] ^ _ ` A= a B= b C= c D= d E=

e F= f G= g H= h I= i J= j K= k L= l M=

m N= n O= o P= p Q= q R= r S= s T= t U=

u V= v W= w X= x Y= y Z= z { | } ~ del

The left range in the above example is speciﬁed by two numeric byte speciﬁcations

separated by a minus sign. Note that the same range can be represented by "A-Z"

(characters), %101-"Z" (octal representation), or 65-90 (decimal representation).

Collating Upper Case Before Lower Case

The following example shows how to use the >ALTSEQ command for collating upper case,

then lower case characters. This is a commonly used alternative to the standard collating

sequence.

:SORT

HP32214A.01.00 SORT/3000 THU, JUN 4, 1987, 8:30 AM

>ALTSEQ MERGE "A-Z" WITH "a-z"

>SHOW SEQUENCE

nul soh stx etx eot enq ack bel bs ht lf vt ff cr so si

dle dc1 dc2 dc3 dc4 nak syn etb can em sub esc fs gs rs us

sp ! " # $ % & ' ( ) * + , - . /

@ A a B b C c D d E e F f G g H

0 1 2 3 4 5 6 7 8 9 : ; < = > ?

h I i J j K k L l M m N n O o P

p Q q R r S s T t U u V v W w X

x Y y Z z [ \ ] ^ _ ` { | } ~ del

The six characters [, \, ], ^, _,'' and ` follow the lower case z. The result of MERGE "A-Z"

WITH "a-z" is as follows:

Original Sorted List Sorted List

List Without MERGE Using MERGE

CAN AXE AXE

shovel BROOM BROOM

MAN CAN boy

BROOM DOG CAN

TABLE MAN DOG

AXE TABLE drawer

drawer boy MAN

boy drawer shovel

DOG shovel TABLE

Collating Lower Case Before Upper Case

The following shows how to use the >ALTSEQ command to collate lower case alphabetic