Thursday, July 29, 2010

Tip 6: Sort LTOU

LTOU is a convenient option in Sort Cards to convert all Lower case alphabets to Upper case. Its most useful as only lower case alphabets are converted to upper case. Numbers, symbols and special characters are unaffected.

Sort card will be as below:

Suppose the file is of length 100 and we want to convert the full file:
SORT FIELDS=COPY
OUTREC FIELDS=(1,100,TRAN=LTOU)

And if we want to convert only the first 10 bytes:
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,10,TRAN=LTOU,11:11,90)

We can also sort on any fields if needed.

No comments:

Post a Comment