I spent too much time in the night pondering a simple way to sort out some data I'm working with. Now I find that there's no REGEXP function in Sqlite that one can use in the select clause?!
@samwilson looks like you can load a library to provide a user defined one? i don't *think* i've actually tried this...
@brennen So far, all I've found is docs about loading a user-defined one that can only be used in the WHERE clause, and not for selecting. What I want to do is chop up a field into various parts, and use those parts elsewhere in the query.
@samwilson ah! hmm. how complex is the field?
@brennen yeah, it looks like I'm heading back to PHP for it. At least then I'll be able to do some other things like open the files for other checking. I just liked the idea of a single SQL query solving all my problems at once!
@samwilson ah, gotcha. that's a kind of string mangling i tend to do at the perl/python/php level, but it feels like there *ought* to be a way to do it in a query.