IBM Mainframe Forum

by **ctrevino** » Thu Mar 29, 2012 7:53 pm

I want to use syncsort to convert a flat file to a comma delimited file.

this is my format
xxxxxx123smith john

First field 6 bytes, second field 3 bytes, last two fields both 20 bytes.

I used this parameter but it overwrote data instead of shifting it.
SORT FIELDS=COPY
INREC FIELDS=(1,6,7:C',',8,3,11:C',',12,20,32:C',',33,20)
OUTREC FIELDS=(1,37)

Help?

Christy

by **BillyBoyo** » Thu Mar 29, 2012 8:06 pm

Your are showing name-looking data, so I guess you have two variable-length fields which you want to put into a fixed format.

You need to look at PARSE. You'll find examples in the forum, or using google, or consulting your manual. Maybe even some of your colleagues have used it.

What do you have as your algorithm for making the split? Names can be curious things.

by **Alissa Margulies** » Thu Mar 29, 2012 9:25 pm

PARSE is used to create fixed-length fields from variable-position and variable-length fields. I'm not convinced that this is the answer.

Christy - please provide sample input records and sample records of your desired output. This will better help us determine exactly what you are attempting to accomplish. Thank you.

by **BillyBoyo** » Thu Mar 29, 2012 9:56 pm

Sorry Alissa. I just "quoted and coded" and the fields are already fixed (in as much as one example can show that). Sorry for not checking earlier, as you probably did.

by **ctrevino** » Fri Mar 30, 2012 12:49 am

sorry. my example got squished on me.

Here is an example:

XXXXXXAAAFFFFFFFFFFFFFFFFFFFFLLLLLLLLLLLLLLLLLLLL

I need commas in between the fields without loss of data. No comma at end.

My code is overlaying like this:
XXXXX,AA,FFFFFFFFFFFFFFFFFFFFF,LLLLLLLLLLLLLLLLLL

by **Alissa Margulies** » Fri Mar 30, 2012 1:42 am

Hello Christy.

If you just want to insert commas between fixed-length fields, then try the following:

Select all

//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
XXXXXXAAAFFFFFFFFFFFFFFFFFFFFLLLLLLLLLLLLLLLLLLLL
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTREC BUILD=(1,6,C',',7,3,C',',10,20,C',',30,20)
/*

Here is the output produced by the above step:

Select all

XXXXXX,AAA,FFFFFFFFFFFFFFFFFFFF,LLLLLLLLLLLLLLLLLLLL

by **ctrevino** » Fri Mar 30, 2012 5:25 pm

worked perfect. Thanks.

IBM Mainframe Forum

Flat file to comma delimited file

Flat file to comma delimited file

Re: Flat file to comma delimited file

Re: Flat file to comma delimited file

Re: Flat file to comma delimited file

Re: Flat file to comma delimited file

Re: Flat file to comma delimited file

Re: Flat file to comma delimited file