Thank you! Worked! Roman ________________________________________ From: sqlite-users-boun...@mailinglists.sqlite.org [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of R Smith [rsm...@rsweb.co.za] Sent: Tuesday, July 05, 2016 3:13 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] replace "\n" with nothing
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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users