Restructure records of file using DFSORT



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

Restructure records of file using DFSORT

Postby Enlighten » Fri Oct 16, 2015 3:53 pm

Hi,

I have a PS file with FB record format having records in the way:

AB001.d9999.sample       
AB001.d9999.sample1
AB001.d9991.sample11
AB001.d99.samp
AB001.d9999.sample190


I want records seen above to shift a position and add a prefix and suffix as can be seen below:

 DELETE AB001.d9999.sample(*)       
 DELETE AB001.d9999.sample1(*)
 DELETE AB001.d9991.sample11(*)
 DELETE AB001.d99.samp(*)
 DELETE AB001.d9999.sample190(*)


Please advise. Your help is highly appreciated.

Thanks in advance.

Code'd
Enlighten
 
Posts: 1
Joined: Fri Oct 16, 2015 3:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restructure records of file using DFSORT

 

Re: Restructure records of file using DFSORT

Postby NicC » Fri Oct 16, 2015 4:23 pm

So you can easily add the DELETE string because you searched the forum and found similar examples, yes?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Restructure records of file using DFSORT

Postby BillyBoyo » Fri Oct 16, 2015 5:27 pm

And for the "(*)", use FINDREP with DO=1 to change two blanks to C'(*)'.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post