Page 1 of 1

delete ; and let white space

PostPosted: Mon Jun 04, 2018 5:44 pm
by samb01
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.

Re: delete ; and let white space

PostPosted: Mon Jun 04, 2018 7:15 pm
by enrico-sorichetti
after 9 years and 250 posts You should be able to search the forum for the answer

Re: delete ; and let white space

PostPosted: Mon Jun 04, 2018 8:00 pm
by samb01
I succeed with this :


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

 

Re: delete ; and let white space

PostPosted: Mon Jun 04, 2018 8:39 pm
by enrico-sorichetti
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

Re: delete ; and let white space

PostPosted: Mon Jun 04, 2018 9:09 pm
by samb01
Thank you. FINDREP seems to be interesting.