Import OS import sys import string #以指定模式打开指定文件, get file handle def getfileins (Filepath,model): Print ("Open file") print (FilePath) Print (model) return open (Filepath,model) #获取需要处理的文件 def getprocfile (path): Return Os.listdir (Path) #判断是否满足某个条件, if full The foot performs def isTrue (outfileins,s): findStr1 = "Line_count_update INTEGER: = 0;" WRITESTR1 = "Line_count_error INTEGER: = 0; --Error data xx bar "FINDSTR2 =" dbms_output. Put_Line (' process complete ' writeStr2 = ' dbms_output. Put_Line (' ERROR data [' | | | line_count_error| | '] '); " FINDSTR3 = "Dbms_output. Put_Line (' Insert data [' | | cur_result.int_id| | '] An exception occurred ... '); " WRITESTR3 = "Line_count_error: = line_count_error+1;" FINDSTR4 = "Dbms_output. Put_Line (' Update data [' | | cur_result.int_id| | '] An exception occurred ... '); " If S.find (findStr1)! = -1:outfileins.write (s) outfileins.write (writestr1+ "\ n") elif S.find (FINDSTR2)! =-1: Outfileins.write (s) outfileins.write (writestr2+ "\ n") elif S.find (FINDSTR3)! = -1:outfileins.write (s) outfi Leins.write ("\t\t\t\t" +writestr3+ "\ n") Elif s.find (FINDSTR4)! = -1:outfileins.write (s) outfileins.write ("\t\t\t\t\t" +writestr3+ "\ n") elif S.find ("C S_oslgis ")! = -1:outfileins.write (S.replace (" Cs_oslgis "," CQ_RMW ")) Elif S.find (" and A.longitude > ")! = -1:o Utfileins.write ("\t\t\tand a.longitude is not Null\n\t\t\tand a.longitude was not Null\n\t\t\tand ROWNUM<2\n") elif S. Find (") LOOP") = -1:outfileins.write ("\t\t) loop\n") Else:outFileIns.write (S.replace ("| |) ', 2", "| | ') ', 3")) # Read and process text Def getandproc (infileins,outfileins): lines = Infileins.readlines () for S in lines: #print (s) isTrue (o utfileins,s) If __name__== "__main__": Infilemod = "r" outfilemod = "W" path = "D:\\rmsdata2gis" for Tmpfile in Os.listdir (path): Infilepath = path+ "\ \" +tmpfile Outfilepath = path+ "\\BAK_" +tmpfile infileins = Getfileins (i Nfilepath,infilemod) Outfileins = Getfileins (outfilepath,outfilemod) Getandproc (infileins,outfileins) inFileIn S.close () Outfileins. Close ()