title: c# mongodb import .csv file columns separated with "|" instead of comma
body: <p>I have a database (named "db").</p>
  
  <p>I want to create a collection named "worker" using a file named "worker.csv". But in this file, columns(id, firstname, lastname) are separated with a "|" character instead of "," character.</p>
  
  <p>I can import the content of this file using this command:</p>
  
  <pre><code>$ mongoimport -d db -c worker --type csv --file worker.csv --headerline
  </code></pre>
  
  <p>After this, I tried to get the number of workers named "Roberto" in my C# code.</p>
  
  <pre><code>var query = Query.Matches("FirstName", "Roberto");
  var users = personCollection.Find(query);
  
  Console.WriteLine(users.Count());
  </code></pre>
  
  <p>In the output, it says "0", but I know there are workers named Roberto.</p>
  
  <p>I tried to see the content of the collection in "mongo.exe" using <code>db.worker.find()</code> command and it seems after the importing operation, a line (of worker.csv) looks like just one attribute instead of three(id, firstname, lastname). And I think it's a problem about the .csv file.</p>
  
  <p>Is there a way to import from this file correctly?</p>