Ah, OK. I have a feeling that needs to be done either in your application code or with a user defined SQLite function. Somebody may prove me wrong.
RBS On 9/10/12, Sébastien Roux <roux.sebast...@gmail.com> wrote: > I want to remove/trim characters strating from "from" til "]" > > Logging in user [aaaaaaaaaa] from [10.165.69.247] > 194|2012-09-07|Logging in user [aaaaa] from [10.296.44.163] > 160|2012-09-04|Logging in user [aaaaaaa] from [10.164.69.248] > 136|2012-09-07|Logging in user [aaa] from [10.168.59.169] > 132|2012-09-07|Logging in user [aaaaaaaaaaa] from [10.169.22.58] > > Sébastien Roux > > > 2012/9/10 Bart Smissaert <bart.smissa...@gmail.com> > >> Could your application supply the values in code? >> What exactly are you trying to do? >> >> RBS >> >> >> >> On 9/10/12, Sébastien Roux <roux.sebast...@gmail.com> wrote: >> > Thanks Bart but substr require hard coded positions I guess, I need to >> get >> > this position dynamically! >> > >> > Sébastien Roux >> > >> > 2012/9/10 Bart Smissaert <bart.smissa...@gmail.com> >> > >> >> http://www.sqlite.org/lang_corefunc.html >> >> >> >> Look at substr >> >> >> >> >> >> RBS >> >> >> >> >> >> On 9/10/12, Sébastien Roux <roux.sebast...@gmail.com> wrote: >> >> > Hi, >> >> > >> >> > I'm looking for the[in]famous sqlite "*instr"* function which >> >> > doesn't >> >> exist >> >> > (searched the web so far without success). Also searched for a >> >> > "*position"*function, without success too! >> >> > >> >> > Any idea or help? I found some threads about custom functions but no >> >> > tutorial nor deeper explanations! >> >> > >> >> > 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 >> > _______________________________________________ > 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
