On Fri, Dec 6, 2019, 4:31 PM Bart Smissaert <bart.smissa...@gmail.com> wrote:
> I know I can do something like this: > > select replace(postcode, rtrim(postcode, replace(postcode, ' ', '')), '') > from addresses > > which will get the part of the postcode starting with the space. > Problem however is how to deal with the forward slash. > Do you have to do this in SQLite itself? Can you load an extension that provides regex? How did you go from comment strings to postcodes? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users