hi Michael , Here my scenario is also like that which you have mentioned bellow. this is my entry in the batch file . first we are creating the sql commands from a index file , and then we are formatting that index file by removing all the rem etc. imp system/manager file=emp.dmp fromuser=scott touser=hr indexfile=objects.sql log=objects.log 2>&1 | %TEE% -a %LOGFILE% rem ----------------------------------------------------------------------------- rem format the objects.sql file to obj.sql rem ----------------------------------------------------------------------------- del obj.sql 2>&1 | %TEE% -a %LOGFILE% sed "s/REM //" objects.sql | sed "/rows/d" | sed -e "s/#.*//" -e "/^$/ d" |sed "s/CONNECT %OraSchemaOwner%//" | sed "1a spool obj.log" | sed "$a\ " | sed "$a\ spool off" | sed "$a\ exit;" >> obj.sql 2>&1 | %TEE% -a %LOGFILE% my case is in the index file a a command is created like the below one REM ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT REM sysdate REM REM REM REM ) ; REM ... 260000 rows it is formatting into ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT sysdate ) ; when this command runs ,it is comming like this SQL> ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT 2 sysdate 3 SQL> SQL> SQL> ) ; SP2-0042: unknown command ") " - rest of line ignored. AND MY REST OF THE COMMANDS IN THE BATCH FILE IS ABORTED.. so i need to include a proper formatting command to ignore the lines in-between this one ALTER TABLE "HR"."EMPLOYEES" MODIFY ("DATE_TIME" DEFAULT sysdate ) ; and need to merge with the ); plz suggest some commands to do the above task which i need to include in this sed "s/REM //" objects.sql | sed "/rows/d" | sed -e "s/#.*//" -e "/^$/ d" |sed "s/CONNECT %OraSchemaOwner%//" | sed "1a spool obj.log" | sed "$a\ " | sed "$a\ spool off" | sed "$a\ exit;" >> obj.sql 2>&1 | %TEE% -a %LOGFILE% Thanks and Regards, Mohammed On Fri, May 15, 2009 at 11:47 AM, Michael Garfield Sørensen <mgs@xxxxxxxx> wrote: > > http://gnuwin32.sourceforge.net/packages/sed.htm = Sed for Windows > > Works like a charm: > ------------------------------------------------------------------ > Microsoft Windows XP [Version 5.1.2600] > (C) Copyright 1985-2001 Microsoft Corp. > > C:\>type sample.sql > REM SELECT * FROM DUAL; > > > C:\>which sed > C:\Program Files\GnuWin32\bin\sed.EXE > > C:\>sed "s/REM //" sample.sql > SELECT * FROM DUAL; > > ------------------------------------------------------------------ > > HTH > Michael Garfield Sørensen, CeDeT > > > Quoting Niall Litchfield <niall.litchfield@xxxxxxxxx>: > >> sed is a unix command line tool. You can get various replacements using >> cygwin or others - if sed is a gnu utility there will likely be a windows >> binary for it, or you can reformulate your problem as a business problem >> rather than a technology issue - for example I need to remove all >> occurrences of a string from a file, preferably using the command line. I'd >> just use ctrl-h in write to do string replacement in a text file fwiw. >> >> Niall >> >> On Fri, May 15, 2009 at 6:35 AM, Mohammed Mehraj hussain < >> mhdmehraj@xxxxxxxxx> wrote: >> >>> hi all , >>> >>> i need to format a file using the sed command on windows . >>> >>> For example iam running this command in my comman prompt of win xp. >>> >>> D:\sample> sed "s/REM //" sample.sql >>> >>> 'sed' is not recognized as an internal or external command, >>> operable program or batch file. >>> >>> >>> >>> >> >> >> -- >> Niall Litchfield >> Oracle DBA >> http://www.orawin.info >> > > > -- //www.freelists.org/webpage/oracle-l