How to sort data

Venugopalsubbiah · New User Joined: 12 Aug 2008 Posts: 7 Location: Bangalore

I need to reorder the records each time. Just reorder the record sequence. Not changing the data within a record.

How can I do this?

Hope it is very clear.

Thanks,
Venu.

PeD · Posted: Wed Aug 20, 2008 1:50 am Post subject:

No comment, but today I would want to ..

Sorry

dick scherrer · Posted: Wed Aug 20, 2008 1:51 am Post subject:

Hello,

Frank Yaeger · Posted: Wed Aug 20, 2008 2:12 am Post subject:

Venu,

Do you mean you want to reorder the records randomly each time you run? I would think you'd need a randomized field in each record that you could change each time and sort on. DFSORT does not have any built-in features to do that kind of thing.

Venugopalsubbiah · New User Joined: 12 Aug 2008 Posts: 7 Location: Bangalore

here you go..

Input:

First name last name sex
aaaaa bbbbbb m
ddddd ffffffffff f
eeeee gggggg f
rrrrrrr tttttttttt m

Output 1: First time:
rrrrrrr tttttttttt m
ddddd ffffffffff f
aaaaa bbbbbb m
eeeee gggggg f

Output 2: Second time:
ddddd ffffffffff f
eeeee gggggg f
aaaaa bbbbbb m
rrrrrrr tttttttttt m

order could be anything....

Frank Yaeger · Posted: Wed Aug 20, 2008 3:07 am Post subject:

See my previous answer.