我的文件是这样的标题1,标题2,标题3,标题4,标题5
Alpha, Beta, gamma, Face, Human
狗、骆驼、马、狮子
################# 总结 ###############################
Heading6 = V8CA02TB Heading7 = 8R1 Heading8 = ENVS2F12SLB2 Heading9 = mkern2 Heading10 = 1654774930624 Heading11 = 09 13:42:10 2022
我想创建这样的文件
Heading1, Heading2, Heading3, Heading4, Heading5, Heading6, Heading7标题8,标题9,标题10,标题11
Alpha, Beta, gamma, Face, Human, V8CA02TB, 8R1, ENVS2F12SLB2, mkern2,1654774930624, 09 13:42:10 2022
猫,狗,骆驼,马,狮子,V8CA02TB, 8R1, ENVS2F12SLB2,Mkern2, 1654774930624,09 13:42:10 2022
我需要在多个文件中这样做然后将所有文件合并到一个文本文件
任何帮助都将不胜感激。
这将解析你的格式
with open('x.data') as fin:
header = None
rows = []
extra = []
for line in fin:
if len(line) < 5:
continue
if not header:
header = line.strip().split(',')
elif 'Summary' in line:
break
else:
rows.append( line.strip().split(',') )
for line in fin:
line = line.strip()
if not line:
continue
left,_,right = line.partition(' = ')
header.append( left )
extra.append( right )
with open('out.data', 'w') as fout:
print( ','.join(header), file=fout )
for row in rows:
print( ','.join(row+extra), file=fout )
输出:
A,B,C,D,E,F,G,H,I,J,K
Alpha, Beta, Gama, Face, Human,V8CA02TB,8R1,ENVS2F12SLB2,mkern2,1654774930624, 09 13:42:10 2022
Cat, Dog, Camel, Horse, Lion,V8CA02TB,8R1,ENVS2F12SLB2,mkern2,1654774930624, 09 13:42:10 2022
合并多个文件很容易,即使没有Python。