View previous topic :: View next topic
|
Author |
Message |
thirumalasetty
New User
Joined: 17 Jun 2014 Posts: 13 Location: india
|
|
|
|
Hi,
I'm trying to remove certain group of records which has got the word "TEST" in it. The file is of 80 byte fixed length. My requirement is to remove all records those have the word "TEST" along with them.
I searched through the forum and found FINDREP, but could not find the PARM / VERB that does SEARCH / FIND function. Can someone please provide directions.
INPUT
Code: |
ABCDTESTFGH
ABCDEFGHIJK
ABTESTCDEFG
TESTABCDEFG
ABCDEFGHIJK |
Expected OUTPUT
Code: |
ABCDEFGHIJK
ABCDEFGHIJK |
Thank you.
Rajesh. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You need to look up what the field-type SS can do for you.
Code: |
OPTION COPY
OMIT COND=(1,80,SS,EQ,C'TEST') |
Edit: Missed the EQ :-) |
|
Back to top |
|
|
thirumalasetty
New User
Joined: 17 Jun 2014 Posts: 13 Location: india
|
|
|
|
Appreciate the quick response Bill. I got the data successfully with the below card; Thank you very much.
Code: |
OPTION COPY
OMIT COND=(1,80,SS,EQ,C'TEST') |
|
|
Back to top |
|
|
|