title: SQL Server Import/Export: How do I create a column delimiter EXCEPTION
body: <p>My column delimiter is a vertical bar "|"
  How do I tell SQL to not create a new column when it sees "\|"</p>
  
  <p>My text files are delimited by a vertical bar, "|".  However sometimes the vertical bar will appear in a name/value, and SQL will split this into separate columns.  To fix this issue, the owner of the data inserted an \ in front of each vertical bar which is NOT a delimiter.</p>
  
  <p>What is the most seamless way to tell SQL Server to not split a field in a separate column when it sees  "\|" as opposed to a normal vertical bar.  Can I use the text qualifier/some other simple method to do this?</p>