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 <[email protected]> wrote: > On Fri, Dec 6, 2019, 4:31 PM Bart Smissaert <[email protected]> > 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
