I have a SQLite database (version 3, created in FME) that I want to use a Select statement with a regular expression in the SQLCreator transformer. According to the SQLite documentation the regexp() user function is a special one that need to be defined. Does anyone know a easy way to do this in FME? (it have to work in both PC and Mac environment)
How to do REGEXP in SQLCreator transformer on a SQLite database
Userlevel 4
- 8177 replies
-
2 December 2019
I was a bit too quick to answer, not realizing that the REGEXP reserved word doesn't work out-of-the-box in SQLite3. So basically you need to provide some precompiled library (e.g. pcre.so for Linux) that is platform-dependent. Unfortunately I have the impression that there are no official repositories or distributors of such libraries.
I've googled around quite a bit but was unable to find any such libraries for Windows, only for Linux (which might possibly work on a Mac, if you're lucky).
What exactly is the use case for REGEXP in the database? Is there perhaps another way to accomplish the same thing?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.