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

Chapter 6 71

SORT-MERGE/XL Commands

ALTSEQ

Q R S T U V W A= 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

The >ALTSEQ command pads X with two blank characters making it equal to ABC in length.

Note the character sp (space) is equated to B and C and the character A is equated to X.

The table position identiﬁed by each character of the left string is replaced by the

corresponding character of the right string until the string ABC is exhausted

Numeric Byte Speciﬁcation

The following example shows how to use the >ALTSEQ command for a numeric byte

speciﬁcation:

:SORT

HP32214A.01.00 SORT/3000 THU, JUN 4, 1987, 8:20 PM

>DATA IS ASCII, SEQUENCE IS ASCII

>ALTSEQ 65=%141

>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 ! " # $ % & ' ( ) * + , - . /

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

@ 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= 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

In this example, the upper case A (represented by the decimal value 65) is assigned the

same ordinal value as the lower case a (represented by the octal value %141) in the ﬁnal

collating sequence.

Using a Range String Speciﬁcation

The following example shows how to use the >ALTSEQ command for a

range string

speciﬁcation:

:SORT

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

>ALTSEQ %101-%132="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