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