Sad! Would you have any link toward SQLite's user defined SQLite function? Many thanks.
Sébastien Roux 2012/9/10 Bart Smissaert <bart.smissa...@gmail.com> > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
