[GRASS-user] sqlite and string function::how can I replace substrings in a table?

[Glynn Clements]

wqual wrote:

> I need to replace substrings in my sqlite-attribute-table (e.g. ß--> ss, ä --> 
> ae etc.). I am wondering, if this is possible (but sqlite says: no such 
> function substring, no such function replace!). 

SQLite has a "substr" function and a concatenation operator ("||"),
but it doesn't have any way to find the index of the character which
you want to replace.

So, you would either have to export the table to a text file and
modify that, or write an extension using SQLite's C/C++ API.

-- 
Glynn Clements <glynn at gclements.plus.com>