Sort Answers



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

Sort Answers

Postby GUI1504 » Fri Nov 19, 2010 6:24 pm

I need to sort the data and remove the 'trash'.

0255
e23709
54862
*
000001*2784856*048467*028475930*
000001*2784856*048467*028475930*
000001*2784856*048467*028475930*


i need just the lines after first asterisk and, remove all asterisks from the data.

000001*2784856048467028475930
0000012784856*048467028475930
0000012784856*048467028475930


Like this /\
GUI1504
 
Posts: 28
Joined: Fri Sep 03, 2010 10:40 pm
Location: Campinas, SP - Brazil
Has thanked: 0 time
Been thanked: 0 time

Re: Sort Answers

Postby GUI1504 » Fri Nov 19, 2010 6:27 pm

sorry about mistakes, i can't edit, so i will repair them:

the final data:

0000012784856048467028475930
0000012784856048467028475930
0000012784856048467028475930



My Sort:
SORT      FIELDS=(0,250,AC,A)
GUI1504
 
Posts: 28
Joined: Fri Sep 03, 2010 10:40 pm
Location: Campinas, SP - Brazil
Has thanked: 0 time
Been thanked: 0 time

Re: Sort Answers

Postby Frank Yaeger » Sat Nov 20, 2010 12:31 am

SORT FIELDS=(0,250,AC,A)

is an invalid statement. The minimum starting position is 1, not 0.

Is the * record always the fourth record, or can it be another record (fifth, third?). Is there only one record in the file with * in position 1 or can there be more than one?

What is the RECFM and LRECL of the input file?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post