Replace the a string with spaces without changing the recl



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

Replace the a string with spaces without changing the recl

Postby jithu » Wed Nov 08, 2017 4:50 pm

Hi All,

I would like to replace input record with spaces once we found PIC clause in the input file.

Input file
Input file.PNG



Expected output

out put.PNG


File record length is 80
expecting Sort methodology.
You do not have the required permissions to view the files attached to this post.
jithu
 
Posts: 3
Joined: Wed Nov 08, 2017 4:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Replace the a string with spaces without changing the re

Postby enrico-sorichetti » Wed Nov 08, 2017 4:58 pm

DO NOT POST IMAGES !
no reason to waste 25K bytes when
a plain text cut and paste from Your 3270 emulator is more than enough
( no more than 1kb bytes )
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: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Replace the a string with spaces without changing the re

Postby jithu » Wed Nov 08, 2017 5:05 pm

Apologies for that . Will keep it in my mind.
jithu
 
Posts: 3
Joined: Wed Nov 08, 2017 4:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Replace the a string with spaces without changing the re

Postby NicC » Wed Nov 08, 2017 6:50 pm

Why do you want to do this? I ask because it may be easier to use the compile listing to extract variable names.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Replace the a string with spaces without changing the re

Postby prino » Wed Nov 08, 2017 8:02 pm

NicC wrote:Why do you want to do this? I ask because it may be easier to use the compile listing to extract variable names.

Sheesh,don't you know by now? It's the requirement!
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: Replace the a string with spaces without changing the re

Postby jithu » Thu Nov 09, 2017 10:03 am

NicC wrote:Why do you want to do this? I ask because it may be easier to use the compile listing to extract variable names.



That is my requirement. I am developing a logic to fetch all variables in the data division using sort. Now i am facing difficulties in formatting the data which i gave?
jithu
 
Posts: 3
Joined: Wed Nov 08, 2017 4:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Replace the a string with spaces without changing the re

Postby Aki88 » Fri Feb 09, 2018 10:24 pm

Hello,

Fairly sure that you'd have found a solution for this by now; just in case you haven't, explore the usage of PARSE keyword in *SORT.
PARSE, coupled with ENDBEFR should give you the desired output.
Aki88
 
Posts: 381
Joined: Tue Jan 28, 2014 1:52 pm
Has thanked: 33 times
Been thanked: 36 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post