title: How to import CSV into SQL Server and Removing characters and unwanted text
body: <p>Hi I am trying to upload this csv file into sql server but there is a lot of unwanted text and characters that is generated on the csv creation from another application.</p>
  
  <p>I think this is more complicated than a row delimiter and column delimiter.</p>
  
  <p>Here is an example of the csv that I would like to upload:</p>
  
  <pre><code>"Report Name: My Keyword Performance Report"
  "Report Time: 6/10/2015"
  "Time Zone: (GMT-08:00) Pacific Time (US &amp; Canada); Tijuana"
  "Last Completed Available Day: 6/11/2015 7:00:00 PM (GMT)"
  "Last Completed Available Hour: 6/11/2015 7:00:00 PM (GMT)"
  "Report Aggregation: Daily"
  "Report Filter: "
  "Potential Incomplete Data: true"
  "Rows: 123"
  
  "GregorianDate","AccountId","CampaignId","Keyword","KeywordId","Device type","BiddedMatchType","Clicks","Impressions","Ctr","AverageCpc","Spend","QualityScore"
  "6/10/2015","8455565","110123754","truck","7695873172","Computer","Exact","4","9","44.44","0.66","2.64","10"
  "6/10/2015","8455565","110123754","truck","7695873172","Smartphone","Exact","2","3","66.67","0.23","0.45","10"
  "6/10/2015","8455565","110123754","truck parts","7695873174","Computer","Exact","5","11","45.45","0.87","4.37","10"
  "6/10/2015","8455565","110123754","truck parts","7695873174","Smartphone","Exact","1","1","100.00","0.14","0.14","10"
  "6/10/2015","8455565","110123754","truck","7695873185","Computer","Exact","289","565","51.15","0.07","21.41","10"
  "6/10/2015","8455565","110123754","truck","7695873185","Smartphone","Exact","64","152","42.11","0.06","3.56","10"
  "6/10/2015","8455565","110123754","truck","7761199395","Computer","Phrase","27","105","25.71","0.44","11.98","10"
  "6/10/2015","8455565","110123754","truck","7761199395","Smartphone","Phrase","4","23","17.39","0.53","2.13","10"
  "6/10/2015","8455565","110123754","truck austin","7695873173","Computer","Exact","0","2","0.00","0.00","0.00","10"
  
  "Ã‚Â©2015 Microsoft Corporation. All rights reserved. "
  </code></pre>
  
  <p>How would I upload this information to SQL Server?  I have no idea how to remove the " and the top 9 rows as well as the bottom row that contains</p>
  
  <blockquote>
  <pre><code>"Ã‚Â©2015 Microsoft Corporation. All rights reserved. "
  </code></pre>
  </blockquote>
  
  <p>Any suggestions or code that could help me?</p>