title: How to fix Unclosed quotation mark in powershell
body: <p>There is a particular email address that look like this in my csv file</p>
  <pre><code>&quot;WZM&quot;,&quot;WZMDSDF&quot;,&quot;Kevin.O'Neil@gmail.com&quot;,&quot;True&quot;,&quot;mb&quot;
  </code></pre>
  <p>I'm inserting it like this to my sql database using like this</p>
  <pre><code> $queryII = &quot;insert into Hold_Inv (Hold,GID,Source,Type,CreatedDate) VALUES ('$($item.Hold)','$($item.GID)','$($item.Source)','$($item.Type)','$CurDate')&quot;
  </code></pre>
  <p>I'm getting this error so just wondering how can I fix this unclosed quotation mark</p>
  <pre><code>Invoke-Sqlcmd : Incorrect syntax near 'Neil@gmail'.
  Unclosed quotation mark after the character string ')
  </code></pre>
  <p>I have other emails in the same csv file like this jonathan.sparkle@gmail.com but I have no issue. Any help or suggestion on how to fix above error will be really appreciated</p>