Harish, neither trigger nor trim will be useful for you directly as such. I suggest writing a custom sqlite function to perform the operation. You try writing custom functions, if I figure out any idea, I will get back to you.
http://www.sqlite.org/c3ref/create_function.html VENKAT Bug the Bugs ________________________________ From: Harish CS <cshar...@gmail.com> To: sqlite-users@sqlite.org Sent: Mon, February 7, 2011 6:01:31 PM Subject: Re: [sqlite] Trigger to filter out characters Venkat, Thanks. But this is not filtering characters. For example, if user enters '12ab34', it should remove 'ab' and enter '1234'. Thanks, Harish venkat easwar wrote: > > Well. I thought it should be an easy deal for you hence left that part. > Now > giving the conditioned trigger assuming the following condition. I leave > the > testing part to your concern. > >>I need to take out the value of A, filter out >> anything other than '0' to '9', '*', '#', '+' 'p', 'w' > > create trigger if not exists <trig_name> after insert on <table_name> when > new.A IN ('0','1','2','3','4','5','6','7','8','9','*','#','+','p','w') > beginupdate <table_name> B=new.A; > end; > > Only if the values inside the braces are inserted it will be copied to > column B. > > > VENKAT > > Bug the Bugs > > > ________________________________ > From: Harish CS <cshar...@gmail.com> > To: sqlite-users@sqlite.org > Sent: Mon, February 7, 2011 2:59:50 PM > Subject: Re: [sqlite] Trigger to filter out characters > > > Hi Venkat, > > Could you please show me how to write the condition (to filter out > characters)? > > Thanks, > Harish > > > > venkat easwar wrote: >> >> Hi Harish, >> >> Yes it is possible. Look below for solution. >> >> create trigger if not exists <trig_name> after insert on <table_name> >> when >> new.A=<condition> >> begin >> update <table_name> B=new.A; >> end; >> >> >> There is nothing tricky or hard for inserting into another table, same >> things >> should go. >> >> VENKAT >> Bug the Bugs >> >> >> >> >> ________________________________ >> From: Harish CS <cshar...@gmail.com> >> To: sqlite-users@sqlite.org >> Sent: Mon, February 7, 2011 2:08:16 PM >> Subject: [sqlite] Trigger to filter out characters >> >> >> Table T has two varchar columns A and B. UI allows entering values into >> column A only. >> On insert/update of records, I need to take out the value of A, filter >> out >> anything other than '0' to '9', '*', '#', '+' 'p', 'w' characters and >> copy >> it to column B. Is it possible to write a trigger to achieve this? If yes >> please give me a sample. (Also, if column B is in another table, is it >> possible?) >> >> Thanks >> -Harish >> >> -- >> View this message in context: >> > http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30861522.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> _______________________________________________ >> 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 >> >> > > -- > View this message in context: > http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30861878.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > 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 > > -- View this message in context: http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30863148.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ 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
