Yes, you are right there.
As rtrim incorporates an instr type of function I am not sure why there
is no plain instr function in SQLite. It would make things a bit simpler.
RBS
On 9/10/12, Black, Michael (IS) <michael.bla...@ngc.com> wrote:
> It might be faster but it doesn't work for anybody who has any letters in
> "from" in their name.
>
> sqlite> insert into t values('132|2012-09-07|Logging in user [tom] from
> [10.169.22.59]');
> sqlite> select rtrim(s,' from [.0123456789]') || ']' 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]
> 132|2012-09-07|Logging in user [t]
>
> The original way still works just fine.
> 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]
> 132|2012-09-07|Logging in user [tom]
> Michael D. Black
> Senior Scientist
> Advanced Analytics Directorate
> Advanced GEOINT Solutions Operating Unit
> Northrop Grumman Information Systems
>
> You have to be very careful when parsing char sets like this to ensure your
> barriers are valid.
> ________________________________________
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
> behalf of Bart Smissaert [bart.smissa...@gmail.com]
> Sent: Monday, September 10, 2012 11:19 AM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] instr function or equivalent
>
> This is slightly faster:
>
> select rtrim(s,' from [.0123456789]') || ']' from t
>
> RBS
>
>
> On 9/10/12, Bart Smissaert <bart.smissa...@gmail.com> wrote:
>> Nice one! Works here.
>>
>> RBS
>>
>>
>> On 9/10/12, Black, Michael (IS) <michael.bla...@ngc.com> wrote:
>>> 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
> _______________________________________________
> 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
