strip quoted newlines from a folder-full of CSV files

strip_quoted_newlines.py

import csv
import re
import glob

for input_filename in glob.glob("./*.csv"):
    print("working on {}".format(input_filename))
    with open(input_filename, 'rU') as infile:
        output_filename = "./strp-{}.csv".format(input_filename.lower().rstrip(".csv").lstrip("./"))
        with open(output_filename, 'a') as outfile:
            output_writer = csv.writer(outfile)
            for input_row in csv.reader(infile):
                for input_pos in range(len(input_row)):
                    input_row[input_pos] = re.sub('\n', ' ', input_row[input_pos])

                output_writer.writerow(input_row)