title: Python remove ' from string when using CSV writer
body: <p>I managed with converting the txt file to .csv with python.</p>
  <p>However, now I don't know how to remove the quotes enclosing all strings in my CSV file.</p>
  <p><a href="https://i.stack.imgur.com/APogj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/APogj.png" alt="enter image description here" /></a></p>
  <p>I tried the following code:</p>
  <pre><code> import csv
  
   with open('UPRN.txt', 'r') as in_file:
   stripped = (line.strip() for line in in_file)
   lines = (line.split(&quot;,&quot;) for line in stripped if line)
   with open('UPRN.csv', 'w', newline='') as out_file:
      writer = csv.writer(out_file)
      writer.writerow(('Name', 'UPRN','ADMIN_AREA','TOWN','STREET','NAME_NUMBER'))
      writer.writerows(lines)
      for lines in writer:
          lines = [x.replace(&quot;'&quot;,&quot;&quot;) if x == '*' else x for x in row]
          writer.writerow(lines)
  </code></pre>
  <p>but I am getting an error:</p>
  <p><strong>TypeError: '_csv.writer' object is not iterable</strong></p>
  <p>The easiest way could be:</p>
  <p><a href="https://stackoverflow.com/questions/40950791/remove-quotes-from-string-in-python">Remove quotes from String in Python</a></p>
  <p>but the CSV writer has no attributes like write, replace, etc.
  <a href="https://stackoverflow.com/questions/20639531/csv-writer-object-has-no-attribute-write">&#39;_csv.writer&#39; object has no attribute &#39;write&#39;</a></p>
  <p>Moreover, I am not sure if a wildcard is needed here:</p>
  <p><a href="https://stackoverflow.com/questions/11427138/python-wildcard-search-in-string">Python wildcard search in string</a></p>
  <p>Is there any quick way of removing the quotes when the CSV module is imported?</p>