in reply to Filter File that have certain word

What is the structure of the file? What is the context in which CLEAR can appear? What database are you using?

For Oracle or DB2, and presumably any other database using SQL, you could do all the inserts, and then perform a ROLLBACK if a record containing "CLEAR" is found.

emc

Any New York City or Connecticut area jobs? I'm currently unemployed.

There are some enterprises in which a careful disorderliness is the true method.

—Herman Melville