如何管理读取csv的问题,这是一个以分号分隔的文件,其中一些字符串包含分号？

我怎样才能摆脱这个特定列中的半冒号,但是没有摆脱所有其他的冒号？

csv模块可以轻松处理这样的工作:

# Contents of input_file.csv
# 4;1;"COFFEE; COMPANY";4
# 3;2;SALVATION ARMY;4

import csv
input_file = 'input_file.csv'  # Contents as shown in your question.

with open(input_file, 'r', newline='') as inp:
    for row in csv.reader(inp, delimiter=';'):
        row[2] = row[2].replace(';', '')  # Removed embedded ';' chars.
        # If you don't care about what's in the column, use the following instead:
        # row[2] = 'xxxxxxxxxxx'  # Value not needed.
        print(';'.join(row))

印刷输出:

4;1;COFFEE COMPANY;4
3;2;SALVATION ARMY;4

import csv
input_file = 'input_file.csv'  # Contents as shown in your question.
output_file = 'output_file.csv'

with open(input_file, 'r', newline='') as inp, \
     open(output_file, 'w', newline='') as outp:
    writer= csv.writer(outp, delimiter=';')
    for row in csv.reader(inp, delimiter=';'):
        row[2] = row[2].replace(';', '')  # Removed embedded ';' chars.
        writer.writerow(row)