划界CSV和剥离空间以生成新的CSV

Question

我有一个CSV文件内容。在这里，定界符是|我想从线路上删除空格。我尝试通过|界定文件界定。但是，将其写入新的CSV时，将空间的每个元素剥离。

|1497/1 |Acerno-1 |1 |99000010119101 |牙花质：数据库树副本|LEGACY_DATA |283 |ofdb_it_siep |

import csv
aList=[]
workingdir = r"C:UsersAkshay.JainDesktopCAREER CONNECT"
csvfile = workingdir+r"1_Wells.csv"
out = csv.writer(open("myfile.csv","w",newline=''),delimiter=',')
with open(csvfile, 'r') as f:
    reader = csv.reader(f, skipinitialspace=True,delimiter='|', quoting=csv.QUOTE_NONE)
    for row in reader:
        for elements in row:
            elements.strip()
            aList.append(row)
        out.writerow(row)

Answer 1

您的行

 out.writerow(row)

再次写入原始的row。尝试

之类的东西

 out.writerow(aList)

（随着aList的创建，将elements移至aList中）或直接修改row，如@Mgilson在注释中指出的那样：

for row in reader:
    row = [x.strip() for x in row]
    out.writerow(row)

Answer 2

import csv
aList=[]
workingdir = r"C:UsersAkshay.JainDesktopCAREER CONNECT"
csvfile = workingdir+r"1_Wells.csv"
out = csv.writer(open("myfile.csv","w",newline=''),delimiter=',')
with open(csvfile, 'r') as f:
    reader = csv.reader(f, skipinitialspace=True,delimiter='|', quoting=csv.QUOTE_NONE)
    for row in reader:
        for elements in row:
            elements.strip()
            aList.append(elements[:-1])  # Add element by element, removing last item.
        out.writerow(aList[1: -1])  # Write list without first or last item, they are ","

输出：

1497/1,ACERNO-1,1,99000010119101,RUCOPY :Database tree copy,LEGACY_DATA,283,OFDB_IT_SIEP