Adding Quotes to Input Records

ksk · Posted: Wed Mar 05, 2008 11:02 pm

Hi,

I have an input file with Account ID from 1st to 16th colomn. I want to add single quotes for each input record in 1st and 17th colomn.

Input file looks like below.

0000000000000001
0000000000000002
0000000000000003

Output should look like below:

'0000000000000001'
'0000000000000002'
'0000000000000003'

We have DFSORT. Can we achieve this using DFSORT?

Record length of my Input and output files 23 and Record Format is FB.

Regards,
KSK

Frank Yaeger · Posted: Wed Mar 05, 2008 11:14 pm

Here's a DFSORT job that will do what you asked for:

ksk · Posted: Thu Mar 06, 2008 10:48 am

Hi Frank,

Thanks very much for your solution. It is working fine.

I have one more requirement here. I also want to add ,(comma) after last quote of each record.

i.e. output should look like below.

'0000000000000001',
'0000000000000002',
'0000000000000003'

Please note that last record should not have comma but all other prior records should have.

I tried with the following sort card but it is giving comma for last record also.

INREC BUILD=(C'''',1,16,C'''',C',',23:X)

And my actual output records are showing like below.

'0010089589511343',
'0010089589511343',
'0010089589562369',
'0010089589562469',

Last highlited comma should not come in my output.

Please let me know the solution.

Regards,
KSK

Frank Yaeger · Posted: Thu Mar 06, 2008 9:33 pm

Here's a DFSORT job for your new requirement:

ksk · Posted: Tue Mar 18, 2008 11:46 am

Thanks Frank. It worked fine.

Regards,
KSK