Sorting on variable length file having variable records



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sorting on variable length file having variable records

Postby Felcy » Sat Nov 12, 2016 2:17 pm

Hi guys,
I am struggling to write a sort on file which is of variable length and the data in it doesn't have fixed position.
Input file is like:
Mark aaaaa
Amy bbbbbbb
Hardy cccc
Positions are not fixed
I want to write a sort on length of field before space , in ascending order.,means to perform ascending sort on length of field before space eg mark,Amy...
Looking forward for your replies.
Thanks in advance
Felcy
 
Posts: 4
Joined: Sat Nov 12, 2016 1:57 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Sorting on variable length file having variable records

Postby NicC » Sat Nov 12, 2016 4:51 pm

Do you mean your output should be:

Amy
Mark
Hardy

'Amy' being 3 bytes and 'Mark' 4 bytes with 'Hardy' 5 bytes?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

These users thanked the author NicC for the post:
Felcy (Sat Nov 12, 2016 6:05 pm)
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Sorting on variable length file having variable records

Postby Felcy » Sat Nov 12, 2016 6:06 pm

Yes nice, it should sort these but on basis of length
Pls help me here, as the positions are not fixed I am struggling to get it.
Felcy
 
Posts: 4
Joined: Sat Nov 12, 2016 1:57 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Sorting on variable length file having variable records

Postby BillyBoyo » Sat Nov 12, 2016 6:17 pm

Are you going to make up your mind where you want this answered?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Sorting on variable length file having variable records

Postby Felcy » Sat Nov 12, 2016 6:25 pm

Hey, I am dealing with data which is kind of unformatted,report data.
Felcy
 
Posts: 4
Joined: Sat Nov 12, 2016 1:57 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Sorting on variable length file having variable records

Postby Felcy » Sat Nov 12, 2016 6:26 pm

NicC wrote:Do you mean your output should be:

Amy
Mark
Hardy

'Amy' being 3 bytes and 'Mark' 4 bytes with 'Hardy' 5 bytes?


Yes rite, waiting for your reply
Felcy
 
Posts: 4
Joined: Sat Nov 12, 2016 1:57 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Sorting on variable length file having variable records

Postby BillyBoyo » Sat Nov 12, 2016 6:48 pm

NicC was just clarifying what you are asking. You'll be waiting a while.

It is considered poor etiquette to ask the same question in multiple places at once. Locking this topic.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post