delete ; and let white space



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

delete ; and let white space

Postby samb01 » Mon Jun 04, 2018 5:44 pm

Hello,

i have a datesat like this :


20180601;CFRA;XDSISO;BVGTFPD;Enabled;
20180601;CFRA;XDSISO;BVGTFPD;Enabled;
20180601;CFRA;XDSISO;BVGTFPD;Enabled;
20180601;CFRA;XDSISO;BVGTFPD;Enabled;
 


is it possible to gei this by dfsort ?



20180601 CFRA XDSISO BVGTFPD Enabled
20180601 CFRA XDSISO BVGTFPD Enabled
20180601 CFRA XDSISO BVGTFPD Enabled
20180601 CFRA XDSISO BVGTFPD Enabled
 


I would like to replace ; by a white space in the whole file.

Thank's for your help.
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: delete ; and let white space

Postby enrico-sorichetti » Mon Jun 04, 2018 7:15 pm

after 9 years and 250 posts You should be able to search the forum for the answer
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3002
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: delete ; and let white space

Postby samb01 » Mon Jun 04, 2018 8:00 pm

I succeed with this :


//REPLACE   EXEC PGM=IKJEFT01                
//SYSTSPRT  DD SYSOUT=*                      
//SYSTSIN   DD *                              
EDIT 'UTBV.BNVG.SEQ' DATA NONUM  
CHANGE * 999999  ';',' ' ALL                  
END SAVE                                      

 
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time

Re: delete ; and let white space

Postby enrico-sorichetti » Mon Jun 04, 2018 8:39 pm

it worked only because the dataset was small ,

a sort based solution will be faster and use less resources
search the dfsort forum section with altseq and/or findrep and/or change
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3002
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: delete ; and let white space

Postby samb01 » Mon Jun 04, 2018 9:09 pm

Thank you. FINDREP seems to be interesting.
samb01
 
Posts: 427
Joined: Mon Nov 16, 2009 7:24 pm
Has thanked: 1 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post