[sqlite] replace extra carriage returns?

I'm trying to clean out a SQLite table that has a text field with multiple carriage returns. I can't figure out how to represent a carriage return in a replace function.This is on a Windows system. I've tried Select Replace(field, '\n','') from table but it doesn't return the data unchanged at

[sqlite] replace extra carriage returns?

How does the replace function identify a windows CRLF? I've tried using \n, \r, \p, 0D0A, etc. I just want to remove multiple carriage returns from a text typed field. Something like: Select replace (field1, '\n\n','\n') from table; I've just started dabbling with SQLite. I mainly work with MSSQL