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: [email protected] [[email protected]] on
behalf of Sébastien Roux [[email protected]]
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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
