title: Delete .csv-column without losing format
body: <p>My file got the format <strong>Unix (LF) with UTF-8-BOM</strong>. It got quotation marks on each column:</p>
  
  <p><a href="https://i.stack.imgur.com/14QVB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/14QVB.png" alt="enter image description here"></a></p>
  
  <p>Now i want to delete the last column. If i save the file with excel as .csv it is formatted in <strong>Windows (CR LF) in ANSI</strong>. It loses the quotation marks:</p>
  
  <p><a href="https://i.stack.imgur.com/aQRd4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aQRd4.png" alt="enter image description here"></a></p>
  
  <p>I wrote a short C# code to remove the last column manually with StreamReader/StreamWriter, but the output is also formatted in <strong>Windows (CR LF) UTF-8</strong>. Curiously it additionally loses some lines.. </p>
  
  <pre><code>string newFilename = tboxFile.Text.Split(new string[] { ".csv" }, StringSplitOptions.None)[0] + "_replaced123.csv";
  
  StreamReader streamReader = new StreamReader(tboxFile.Text);
  StreamWriter streamWriter = new StreamWriter(newFilename);
  
  string line = streamReader.ReadLine();
  streamWriter.WriteLine(line.Split(new string[] { ";\"@timestamp\"" }, StringSplitOptions.None)[0]);
  
  while ((line = streamReader.ReadLine()) != null)
      streamWriter.WriteLine(line.Split(new string[] { ";\"2017-11-" }, StringSplitOptions.None)[0]);
  </code></pre>
  
  <p>So.. Is there a special excel-trick to save the output in same format (Unix LF UTF-8-BOM) or how can i help me?</p>