Enormous! Thanks it works!
Sébastien Roux
2012/9/10 Black, Michael (IS) <michael.bla...@ngc.com>
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
