Is there a simple way to replace portions of a string using the regex
function of sqlite without actually accessing any specific DB entres.
Similar to
SELECT strftime('%s','now') as unixtimestamp
what just returns the result in unixtimestamp... just that I need to perform
regex on a normal string and return the result as a new string.
Probably something like (logics wise)
SELECT replace('#</*\w+:\w[^>]*+>#i', '', string_to_modify) as result
Sorry if this sounds like a stupid questions... but totally new to sqlite
and its possibilities.
Rick
