按行读取txt文件,对每行摘取想要的信息
拼接字符串
追加到文件
要读取的数据
S7Program(1线)/TI-3530C
S7Program(1线)/TI-3531C
S7Program(1线)/TI-3532C
S7Program(1线)/TI-3533C
S7Program(1线)/TI-3534C
S7Program(1线)/TI-3535C
S7Program(1线)/TI-3536C
拼接成为
('SL3aP1081', '工艺指标', 'SL3a/PI-1081', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1071', '工艺指标', 'SL3a/TI-1071', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1072', '工艺指标', 'SL3a/TI-1072', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1140B', '工艺指标', 'SL3a/TI-1140B', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1140A', '工艺指标', 'SL3a/TI-1140A', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1091', '工艺指标', 'SL3a/TI-1091', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1130A', '工艺指标', 'SL3a/TI-1130A', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
('SL3aT1130B', '工艺指标', 'SL3a/TI-1130B', 0, '', '℃', '双辽三线池底', 1, 'SL3cd', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),
def extract_after_slash(filename):
results = []
with open(filename, 'r', encoding='utf-8') as file:
for line in file:
# 去掉行末的换行符和空格
line = line.strip()
# 找到最后一个 '/' 的位置
slash_index = line.rfind('/')
if slash_index != -1:
# 提取 '/' 后面的字符串
results.append(line[slash_index + 1:])
return results
# 使用函数
filename = '临时.txt' # 替换为你的文件名
extracted_strings = extract_after_slash(filename)
# 打印结果
for string in extracted_strings:
# print(string,string.replace("I", "").replace("-", ""))
strget=string.replace("I", "").replace("-", "")
string_to_append = f"('SL3a{strget}', '工艺指标', 'SL3a/{string}', 0, '', '℃', '双辽三线退火', 1, 'SL3th', 1, 'avg', 24, NULL, NULL, NULL, NULL, NULL, 2, NULL, 0, 1),\n"
# 以追加模式打开文件
with open('example.txt', 'a', encoding='utf-8') as file:
file.write(string_to_append)