title: Maintain comma in data while changing delimiter
body: <p>I have a csv file that I need to change the delimiter to a pipe character, however I cannot find the right way to call csv writer to preserve commas in my data.</p>
  <p>Example data below:</p>
  <pre class="lang-none prettyprint-override"><code>Record Type, Participant Full Name, Product Title
  N,&quot;Calvin Harris, The Weekend&quot;, Over Now
  </code></pre>
  <p>Current script:</p>
  <pre><code>reader = csv.reader(open(filein,encoding='utf-8'), delimiter=',', quotechar='&quot;')
  writer = csv.writer(open('Detail_Test_Piped.csv', 'w',newline='',encoding='utf-8'), 
      delimiter='|',quotechar='&quot;',quoting=csv.QUOTE_MINIMAL)
  </code></pre>
  <p>Desired output:</p>
  <pre class="lang-none prettyprint-override"><code>Record Type|Participant Full Name|Product Title
  N|Calvin Harris, The Weekend|Over Now
  </code></pre>
  <p>Current actual output:</p>
  <pre class="lang-none prettyprint-override"><code>Record Type|Participant Full Name|Product Title
  N|Calvin Harris|The Weekend|Over Now
  </code></pre>
  <p>Screenshot of actual data file<a href="https://i.stack.imgur.com/f4Se2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/f4Se2.png" alt="enter image description here" /></a></p>