Use python to change the SQL format file to the desired format,

Use python to change the SQL format file to the desired format,

Insert into ttt (NSAME, ID, AGE) VALUES ('aaa', '20140901', '22 ');

Change the preceding SQL format 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 \ "extends nmbb1_'.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 into a folder.