關(guān)于python處理文本文件實(shí)現(xiàn)生成指定格式文件,很多朋友都不知道該怎么弄。
下面是具體代碼,希望對大家有幫助
可以在下面復(fù)制:
import os
import sys
import string
#以指定模式打開指定文件,獲取文件句柄
def getFileIns(filePath,model):
print("打開文件")
print(filePath)
print(model)
return open(filePath,model)
#獲取需要處理的文件
def getProcFile(path):
return os.listdir(path)
#判斷是否滿足某個(gè)條件,如果滿足則執(zhí)行
def isTrue(outFileIns,s):
findStr1 = "LINE_COUNT_UPDATE INTEGER := 0;"
writeStr1 = "LINE_COUNT_ERROR INTEGER := 0; --錯(cuò)誤數(shù)據(jù)XX條"
findStr2 = "DBMS_OUTPUT.PUT_LINE('處理完畢"
writeStr2 = "DBMS_OUTPUT.PUT_LINE('錯(cuò)誤數(shù)據(jù)['||LINE_COUNT_ERROR||']條.');"
findStr3 = "DBMS_OUTPUT.PUT_LINE('插入數(shù)據(jù)['||CUR_RESULT.INT_ID||']時(shí)發(fā)生異常...');"
writeStr3 = "LINE_COUNT_ERROR := LINE_COUNT_ERROR+1;"
findStr4 = "DBMS_OUTPUT.PUT_LINE('更新數(shù)據(jù)['||CUR_RESULT.INT_ID||']時(shí)發(fā)生異常...');"
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)
outFileIns.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("CS_OSLGIS") != -1:
outFileIns.write(s.replace("CS_OSLGIS","CQ_RMW"))
elif s.find("AND A.LONGITUDE >") != -1:
outFileIns.write("\t\t\tAND A.LONGITUDE IS NOT NULL\n\t\t\tAND A.LONGITUDE IS 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"))
#讀取并處理文本
def getAndProc(inFileIns,outFileIns):
lines = inFileIns.readlines()
for s in lines:
#print(s)
isTrue(outFileIns,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(inFilePath,inFileMod)
outFileIns = getFileIns(outFilePath,outFileMod)
getAndProc(inFileIns,outFileIns)
inFileIns.close()
outFileIns.close()