Does this work for you? SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(s); sqlite> insert into t values('Logging in user [aaaaaaaaaa] from [10.165.69.247]'); sqlite> insert into t values('194|2012-09-07|Logging in user [aaaaa] from [10.296.44.163]'); sqlite> insert into t values('160|2012-09-04|Logging in user [aaaaaaa] from [10.164.69.248]'); sqlite> insert into t values('136|2012-09-07|Logging in user [aaa] from [10.168.59.169]'); sqlite> insert into t values('132|2012-09-07|Logging in user [aaaaaaaaaaa] from [10.169.22.58]'); sqlite> select rtrim(rtrim(s,']'),'.1234567890[ from') from t; Logging in user [aaaaaaaaaa] 194|2012-09-07|Logging in user [aaaaa] 160|2012-09-04|Logging in user [aaaaaaa] 136|2012-09-07|Logging in user [aaa] 132|2012-09-07|Logging in user [aaaaaaaaaaa]
Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Sébastien Roux [roux.sebast...@gmail.com] Sent: Monday, September 10, 2012 10:22 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] instr function or equivalent Sad! Would you have any link toward SQLite's user defined SQLite function? Many thanks. Sébastien Roux _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users