Thank you! Worked! Roman ________________________________________ From: [email protected] [[email protected]] on behalf of R Smith [[email protected]] Sent: Tuesday, July 05, 2016 3:13 PM To: [email protected] 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
