SORT-MERGE/XL General User's Guide (32650-90883)
44 Chapter3
Using SORT/XL Interactively
Defining Your Own Collating Sequence
This translation table display is followed by a display of the contents of the ALTSEQ array
in decimal format and octal word format. This information is not shown here as it is
intended for programmatic use. Refer to the SORT-MERGE/XL Programmer's Guide
(32650-90080) for additional information.
To receive a copy of the standard ASCII translation table from the printer, use the OFFLINE
parameter of the >SHOW command, as follows:
>DATA IS ASCII, SEQUENCE IS ASCII
>SHOW TABLE, OFFLINE
For additional information on translation tables refer to the >SHOW command in Chapter 6.
Defining Your Own Collating Sequence
You can define a customized collating sequence unique to your application. For example, in
the section "Collating Sequences" in Chapter 2, an example was used where an accountant
wanted the special character $ to follow the D in the collating sequence. This makes it
possible to have $ INVENTORY follow DOLLAR INVENTORY but come before other entries,
such as EXPENSES.
To alter the standard sequence so $ INVENTORY follows DOLLAR INVENTORY, but comes
before EXPENSES, enter the following commands:
:SORT
HP32214A.01.00 SORT/3000 WED, JUN 3, 1987, 9:30 AM
© HEWLETT-PACKARD CO. 1986
>DATA IS ASCII, SEQUENCE IS ASCII
>ALTSEQ MERGE "D" = "$"
>SHOW SEQUENCE
nul soh stx etx eot enq ack bel bs ht lf vt ff cr so si
del dc1 dc2 dc3 dc4 nak syn etb can em sub esc fs gs rs us
sp ! " # % & ' ( ) * + , - . / 0
1 2 3 4 5 6 7 8 9 : ; < = > ? @
A B C D $ E F G H I J K L M N O
P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o
p q r s t u v w x y z { | } ~ del