Purusothaman Ramanujam

Purusothaman Ramanujam

Personal Blog

18 Jan 2012

Add leading and trailing Characters in Sort

Lets assume that we have a sequential dataset with records as below:

ONE
TWO
THREE
FOUR
FIVE

I want to reformat the records for output as follows:

NUMBER 'ONE'
NUMBER 'TWO'
NUMBER 'THREE'
NUMBER 'FOUR'
NUMBER 'FIVE'

You can do this quite easily with DFSORT’s JFY function as follows:

OPTION COPY

INREC BUILD=(1,13,JFY=(SHIFT=LEFT,LEAD=C’NUMBER ‘’’, TRAIL=C’’’’)

SHIFT=LEFT left-justifies the data. LEAD inserts the hard coded text NUMBER ’ before the value with no intervening blanks.

TRAIL inserts ’ after the value with no intervening blanks.

Categories