title: How to remove carriage returns in a text field in sqlite?
body: <p>I have an sqlite database with over 400k records. I have just found that some of the text fields have carriage returns in them and I wanted to clean them out. I wanted to copy the structure of the original table and then do something like: </p>
  
  <pre><code>INSERT INTO large_table_copy 
  SELECT date, other_fields, replace(dirty_text_field,XXX,"") 
  FROM large_table
  </code></pre>
  
  <p>Where <code>XXX</code> is whatever the code would be for a carriage return. It's not <code>\n</code>. But I can't find out what it is. </p>