Python Forum
replace string inside double quotes
Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
replace string inside double quotes
#9
(Apr-25-2017, 08:18 PM)jmpatx Wrote:
import csv

new_rows_list = []

# Read File
f1 = open('in_file', 'r')
reader = csv.reader(f1, delimiter=',')
for row in reader:
    new_row = ([col.replace(',', '^') for col in row])
    new_rows_list.append(new_row)


# Write File
f2 = open('out_file', 'w')
writer = csv.writer(f2)
writer.writerows(new_rows_list)
f2.close()
f1.close()

Don't store the whole file in memory, just work on it line-by-line:

import csv

with open("in_file", "r", newline="") as f1:
    reader = csv.reader(f1, delimiter=",")
    with open("out_file", "w", newline="") as f2:
        writer = csv.writer(f2)
        for row in reader:
            new_row = [col.replace(",", "^") for col in row]
            writer.writerow(new_row)
Reply


Messages In This Thread
replace string inside double quotes - by jmpatx - Apr-21-2017, 08:58 PM
RE: replace string inside double quotes - by jmpatx - Apr-24-2017, 03:32 PM
RE: replace string inside double quotes - by nilamo - Apr-24-2017, 03:43 PM
RE: replace string inside double quotes - by jmpatx - Apr-24-2017, 10:29 PM
RE: replace string inside double quotes - by wavic - Apr-25-2017, 04:16 AM
RE: replace string inside double quotes - by jmpatx - Apr-25-2017, 08:18 PM
RE: replace string inside double quotes - by nilamo - Apr-26-2017, 05:08 AM
RE: replace string inside double quotes - by nilamo - Apr-26-2017, 05:27 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Need to replace a string with a file (HTML file) tester_V 1 790 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  Replace string in a nested Dictianory. SpongeB0B 2 1,230 Mar-24-2023, 05:09 PM
Last Post: SpongeB0B
  Replace with upper(string) WJSwan 7 1,616 Feb-10-2023, 10:28 AM
Last Post: WJSwan
  Need help on how to include single quotes on data of variable string hani_hms 5 2,094 Jan-10-2023, 11:26 AM
Last Post: codinglearner
  Find and Replace numbers in String giddyhead 2 1,257 Jul-17-2022, 06:22 PM
Last Post: giddyhead
  Replace String in multiple text-files [SOLVED] AlphaInc 5 8,197 Aug-08-2021, 04:59 PM
Last Post: Axel_Erfurt
  Replace String with increasing numer [SOLVED] AlphaInc 13 5,097 Aug-07-2021, 08:16 AM
Last Post: perfringo
  Remove single and double quotes from a csv file in 3 to 4 column shantanu97 0 7,017 Mar-31-2021, 10:52 AM
Last Post: shantanu97
  Two types of single quotes Led_Zeppelin 2 1,930 Mar-15-2021, 07:55 PM
Last Post: BashBedlam
  How to replace on char with another in a string? korenron 3 2,383 Dec-03-2020, 07:37 AM
Last Post: korenron

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020