> Select Replace(field, '\n','') from table but it doesn't return the
> data unchanged at all. If I take the \n out of single quotes I just
> get an error.
What made you think that SQLite will understand C-style
escape-sequences? It doesn't do that. If you're running this query
from sqlite3
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
> Also, is there a more comprehensive function list other
> than http://www.sqlite.org/lang_corefunc.html ?
If you look closely at http://www.sqlite.org/lang.html you'll find these links:
http://www.sqlite.org/lang_corefunc.html
http://www.sqlite.org/lang_aggfunc.html
Hi Matt,
Regarding:
"Is there a more comprehensive function list other than
http://www.sqlite.org/lang_corefunc.html;
Is there an sqlite-supported function that's not listed there, or are
you saying you want more functions?
If the latter, sqlite struggles to keep the "lite" on, but you can
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
5 matches
Mail list logo