替换.htb文件中的每n个逗号

Question

我的目标是将一个.htb文件导入到mysql表中。但在此之前，我需要编辑文件并将每个第96个逗号替换为\n。原因是mysql tabe有96列，对于导入，我需要插入\n作为行的分隔符。原始文件包含逗号分隔的值：

68.000000000000,89.000000000000,115.000000000000,0.500000000000,

我曾尝试使用以下代码，但它将所有逗号都替换为\n：

with open("C:/Users/l-reh/Desktop/HTB_neu/Iveco_Cursor_DMC_Aufbereitet.htb", "r") as infile, \
     open("C:/Users/l-reh/Desktop/HTB_neu/Final.htb", "w", encoding="utf8") as outfile:
    data = infile.read()
    data = data.replace(','[:96], '\n')
    outfile.write(data)

Answer 1

我相信这会给你想要的结果

with open("C:/Users/l-reh/Desktop/HTB_neu/Iveco_Cursor_DMC_Aufbereitet.htb", "r") as infile, \
    open("C:/Users/l-reh/Desktop/HTB_neu/Final.htb", "w", encoding="utf8") as outfile:
    data = infile.read()
    newData = ''
    n = 0
    for element in data:
        if element == ',':
            n += 1
            if n == 96:
                newData += '\n'
                n = 0
            else:
                newData += element
        else:
            newData += element
    outfile.write(newData)