On 3 Aug 2017, at 3:33pm, petern <peter.nichvolo...@gmail.com> wrote:
> The deeply nested string replace pattern comes up frequently. A > suggestion. Why not a built in aggregate replace function? Two more suggestions: Create a function which does exactly what you want. Call it removePunctuation(p1). Feed it a string and it removes everything which isn’t alphanumeric. Or however it is you define punctuation. Create a function called removeTheseCharacters(p1, p2). Feed it p1 which is a string, and p2 which is another string make up of any number of characters. function returns a value which is p1 with all the characters in p2 removed. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users