eg:CREATE VIEW AIPKEYITEM.SEASONGROUPNETSALES ( CALENDARID , PRODUCTGROUPID FOR COLUMN PRDGRPID   , NETSALESDOLLARS FOR COLUMN NETSA00001 , NETSALESUNITS FOR COLUMN NETSA00002 ) AS SELECT          (SELECT MIN(CALENDARID)              FROM AIPKEYITEM.KEYIT00002              WHERE FISCALYEAR = CAL.FISCALYEAR              AND FISCALSEASON = CAL.FISCALSEASON) CALENDARID      , PRODUCTGROUPID      , SUM(NETSALESDOLLARS) NETSALESDOLLARS      , SUM(NETSALESUNITS) NETSALESUNITS      FROM AIPKEYITEM.KEYIT00002 CAL      INNER JOIN AIPKEYITEM.WEEKG00001 WEEKGROUPORGUNITUNITSDOLLARS      ON CAL.CALENDARID = WEEKGROUPORGUNITUNITSDOLLARS.CALENDARID      GROUP BY CAL.FISCALYEAR, CAL.FISCALSEASON, PRODUCTGROUPID ; In the above example I want to remove entire word starting from FOR COLUMN in which line it is present.
I want to delete from particular words in all the line if that particular word is present
shell script;command line;linux mint;stack
How about:cat myscript | sed 's/FOR COLUMN.*$//g' > myscript.filteredwhen myscript is the name of the file which is shown above?  Is that what you wish to achieve?