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 <[email protected]> > Could your application supply the values in code? > What exactly are you trying to do? > > RBS > > > > On 9/10/12, Sébastien Roux <[email protected]> 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 <[email protected]> > > > >> http://www.sqlite.org/lang_corefunc.html > >> > >> Look at substr > >> > >> > >> RBS > >> > >> > >> On 9/10/12, Sébastien Roux <[email protected]> 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 > >> > [email protected] > >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > >> _______________________________________________ > >> sqlite-users mailing list > >> [email protected] > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
