I can do it in code. This is B4A on Android phone. For that reason can't do UDF's or extensions. This postcode thing was just a simple example, not to do with comment issue.
RBS On Fri, Dec 6, 2019 at 11:48 PM Scott Robison <sc...@casaderobison.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users