Page 1 of 1

Sort Answers

PostPosted: Fri Nov 19, 2010 6:24 pm
by GUI1504
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 /\

Re: Sort Answers

PostPosted: Fri Nov 19, 2010 6:27 pm
by GUI1504
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)

Re: Sort Answers

PostPosted: Sat Nov 20, 2010 12:31 am
by Frank Yaeger
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?