Remove Special Characters from Input File

How to remove ! containing records from a file using JCL. The data without ! is required in the output file.
  • Interview Candidate
  • 18
  • 14815

Showing Answers 1 - 18 of 18 Answers

Sachs

  • Jul 7th, 2015
 

You can do this DFSORT OMIT
Say your records starts at position 1 and ends at position 10
Code like:

OMIT COND= (1, 10, CH, EQ, C !)
here,
CH- type i.e. character
EQ- equal to i.e. relational operator

Anyone wants to correct?
welcome!

  Was this answer useful?  Yes

Muthulakshmi

  • Mar 4th, 2016
 

OMIT condition will omit the entire record right?
Correct me if I am wrong.

  Was this answer useful?  Yes

mayur

  • Nov 23rd, 2016
 

Omit will omit the complete record where it finds the matching condition. If we know the location of special char data, we can reformat data using INREC FIELDS option. where we can omit that column and include remaining data location.
correct me, if I am wrong...

  Was this answer useful?  Yes

Ravi Mishra

  • Feb 7th, 2017
 

We can do this with sort
Sort fields = copy
Outrec FINDREP=(IN=c-,out=c)

  Was this answer useful?  Yes

Nagaraju

  • May 23rd, 2017
 

Using DFSORT utility, In sort control card use OMIT COND.

  Was this answer useful?  Yes

shashank

  • Feb 15th, 2018
 

sort fields=copy
Outrec overlay(1:1,8,UFF)
The above code should work ,UFF remove junk character

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions