IBM Mainframe Forum

As per my JCL. the output looks like below. Here i want to omit the data that comes after numeric digits(omit the all data starts from "FOR')

Hello,

Look up PARSE function of DFSORT in the 'DFSORT Application Programming Guide'.
Few assumptions before the solution, since you have not specified the length of the 'number' that can appear before 'FOR', I have assumed that there can be 50 characters at maximum before 'FOR' appears. Next, you have not specified if the input file is fixed length or variable, I have assumed it to be of fixed length. You have not shown the expected output, I have assumed that the output looks something as below:



A quick and dirty solution:



Hth.

One small point, which is that there is a blank before the FOR. ENDBEFR=C' FOR' or simply ENDBEFF=BLANK will do. It won't matter for the result of fixed-length output, but someone looking at the code later may wonder about that blank, so don't give them an opportunity to wonder

Hi Aki88,

The data which i posted is the output of sort jcl. My input file is VBA.There are 73 characters before "FOR". Only 10 characters after "FOR". I want to eliminate the characters after "FOR" in my output. I'm using include condition in my JCL.

Well, you apply Aki88's solution to your data. You can't use INCLUDE for this, INCLUDE/OMIT COND and INCLUDE=/OMIT= operate at the record level.



The PARSE pads up to 73 bytes, the VLTRIM=C' ' will chop off the trailing blanks for the final output, automatically adjusting the record-length.

Hello Billy,

I second your point

Thank you.