replace(columname, char(10), '');
Sometimes, depending on your OS's interpretation of '\n', it might
actually be char(13)+char(10) or such (that's hex 0x0D and 0x0A). Get
the HEX() from such a line to be sure.
On 2016/07/05 9:00 PM, Roman Fleysher wrote:
Dear SQLiters,
I made a mistake and inserted a new line char, "\n" in the middle of a text. I
now would like to replace it with nothing. Something like:
replace(columnName, '\n','')
But this will interpret "\n" literally, as two symbols. How do I do it?
Thank you,
Roman
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
