Sorting comma separated file

nareshdacha · New User Joined: 12 Jan 2010 Posts: 66 Location: US

I have a input file as below

12345,testing testing,324
9876,new testing,6759
567,test,78963
24345, new testing testing,32433

Length of the each field may vary for each record, i need to sort this file.
based on 3rd field.
i need the output as specified below.....

12345 testing testing 324
9876 new testing 6759
567 test 78963
24345 new testing testing 32433

I have searched this but i got info for fixed length fields. In my case its variable length... By using SORT how to get the output.....
Suggest me how to proceed....

Garry Carroll · Posted: Wed Aug 25, 2010 6:23 pm

Have a look at www-947.ibm.com/systems/support/storage/software/sort/mvs/tricks/pdf/sorttrck.pdf where there's is information on processing CSV files. The PARSE function is what you need.

Garry.

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

nareshdacha,

dick scherrer · Posted: Wed Aug 25, 2010 8:09 pm

Hello,

Garry Carroll · Posted: Wed Aug 25, 2010 8:16 pm

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

dick scherrer,
Unless I am missing any part of OP's post.

dick scherrer · Posted: Wed Aug 25, 2010 8:39 pm

Good catch - i'm eye-lexic today (in addition to being key-lexic). . .

Looked at it multiple times and convinced myself that there were only 4 digits in the 7xxx number.

Been one of those weeks. . .

d

nareshdacha · New User Joined: 12 Jan 2010 Posts: 66 Location: US

Thanks Garry....
Thank to all.....
I have gone thru the Garry's link and i got the output.....
Here a small question here....

My input is...

12345,target testing,9876
3456,new testing,987612
45672,testing,56789

Output is....

12345target testing 9876
3456new testing 987612
45672testing 56789

how to get the leading zeroes for the numeric fields if that field has less than specified length...

I need the output as follows:

12345target testing 009876
03456new testing 987612
45672testing 056789

Sort Card:

SORT FIELDS=COPY
INREC PARSE=(%00=(ENDBEFR=C',',FIXLEN=5),
%01=(ENDBEFR=C',',FIXLEN=20),
%02=(FIXLEN=6)),
BUILD=(%00,%01,%02)
OUTREC BUILD=(1,5,SQZ=(SHIFT=RIGHT),6,20,26,6,SQZ=(SHIFT=RIGHT))

Can any suggest me ...........

gcicchet · Posted: Thu Aug 26, 2010 11:29 am

Hi,

try this

nareshdacha · New User Joined: 12 Jan 2010 Posts: 66 Location: US

Thanks Gcicchet,it worked out......

Thanks to all for your suggestion.......

nareshdacha · New User Joined: 12 Jan 2010 Posts: 66 Location: US

My input is

1st field length = 5
2nd field length= 20
3rd field length=6

-2345,target testing,-9
-345,testing testing data,-89

I got the output like this

02345target testing 000009
02345testing testing data 000089

instead of sign symbol i got the space....

Required Output:
-02345target testing-000009
-00345testing testing data-000089

I have used the below sort card..

SORT FIELDS=COPY
INREC PARSE=(%00=(ENDBEFR=C',',FIXLEN=5),
%01=(ENDBEFR=C',',FIXLEN=20),
%02=(FIXLEN=6)),
BUILD=(%00,%01,%02)
OUTREC BUILD=(1,5,UFF,EDIT=(STTTTT),SIGNS=(,'-','-','-'),6,20,
26,6,UFF,EDIT=(STTTTTT),SIGNS=(,'-','-','-'))

can anyone correct me..

smijoss · Active User Joined: 30 Aug 2007 Posts: 114 Location: pune

a llittle research at your end, and u would have found out that
U of the UFF stands for UNSIGNED

for signed input u need to use SFF.