how to append characters in a record using sort

vishal_a · New User Joined: 24 May 2005 Posts: 45 Location: Noida

hi team,

I have a file with 300,000 records , my requirement is to append three characters in front of every record.

for ex :

the records are in the shape of policies :

CONVTS8387TSD
CONVTS3474LIA
AAVT746464ESA

I want to append 'NLI' in front of every policy my resulting dataset should look like :

NLICONVTS8387TSD
NLICONVTS3474LIA
NLIAAVT746464ESA

Frank Yaeger · Posted: Sat Feb 18, 2006 4:34 am

What is the RECFM and LRECL of your input file?

vishal_a · New User Joined: 24 May 2005 Posts: 45 Location: Noida

Hi frank,

the lrecl is 500 and recfm is FB for my input file

thanks

fixdoubts · New User Joined: 21 Oct 2005 Posts: 54

Hi,
This would do think.

vishal_a · New User Joined: 24 May 2005 Posts: 45 Location: Noida

Thanks fixdoubts,

It worked fine...

regards
Vishal