Change the SQL format file to the format you want with Python

INSERT into TTT (Nsame, ID, age) VALUES (' AAA ', ' 201023210816 ', ' 22 ');

Change the SQL format above to the following format

Aaa|201023210816|22

Import oslists=[]paths = OS.GETCWD () for root,dirs,files in Os.walk (' Wfyh '): For    fn in files:        lists.append (FN) For NMB in lists:    dfile=open ("wfyh\\" +NMB, ' R ')    nmbb=nmb.replace ('. sql ', ')    ofile=open ("wf_test\\" + nmbb+ '. txt ', ' W ') lists=[] for line in    dfile:        m=line.split (' (') [2].replace ('); ', '). Replace (', ', ' | '). Replace (' \ ', ')        t = '. Join (M.split ())        Lists.append (t) for linet in    lists:        ofile.write (linet+ ' \ n ') dfile.close () Ofile.close ()

Write the converted TXT file to a folder

Change the SQL format file to the format you want with Python