You see a view field can run javascript and send events back to the parent, whether web or user. in this case you use the javascript REGEXP.
On Thu, Apr 15, 2010 at 5:40 PM, cpgold <[email protected]> wrote: > Its what I use to dynamicall format phone numbers on the fly. > > > On Thu, Apr 15, 2010 at 5:39 PM, cpgold <[email protected]> wrote: > >> If it is an active link, I have a View field javascript event solution... >> >> >> On Thu, Apr 15, 2010 at 5:39 PM, cpgold <[email protected]> wrote: >> >>> Does it have to be a filter, an active link is much better suited for >>> this type of processing than to let the server handle it. >>> >>> >>> On Wed, Apr 14, 2010 at 1:58 PM, Joe D'Souza <[email protected]> wrote: >>> >>>> I do not have access to an Oracle instance at the moment to try it, but >>>> I'm >>>> quite sure that >>>> >>>> update tablename set columnname = REPLACE('Does work', 'Does ', NULL); >>>> commit; >>>> >>>> would update the column to 'work'. Which is ideally what you would want >>>> it >>>> to.. >>>> >>>> With MS-SQL it sets the column to NULL. >>>> >>>> Joe >>>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> [mailto:[email protected]]on Behalf Of Jim Fox >>>> Sent: Wednesday, April 14, 2010 2:03 PM >>>> To: [email protected] >>>> Subject: Re: Extracting digits from a character field >>>> >>>> >>>> You mean works incorrectly. LOL. >>>> >>>> F >>>> Sent from my Verizon Wireless BlackBerry >>>> >>>> -----Original Message----- >>>> From: Joe D'Souza <[email protected]> >>>> Date: Wed, 14 Apr 2010 13:25:31 >>>> To: <[email protected]> >>>> Subject: Re: Extracting digits from a character field >>>> >>>> You are right, I just tried and it sets the whole column to NULL instead >>>> of >>>> just replacing the specific characters in expression 2 to NULL.. It >>>> works >>>> correctly in Oracle to the best of my knowledge.. >>>> >>>> Joe >>>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> [mailto:[email protected]]on Behalf Of Jim Fox >>>> Sent: Wednesday, April 14, 2010 1:00 PM >>>> To: [email protected] >>>> Subject: Re: Extracting digits from a character field >>>> >>>> >>>> Replaciing a character with Null is an oxymoron in MS-SQL. You would >>>> replace >>>> a character with a zero-length string. Null and "" are not the same. >>>> >>>> Fluxman >>>> Sent from my Verizon Wireless BlackBerry >>>> >>>> -----Original Message----- >>>> From: Joe D'Souza <[email protected]> >>>> Date: Wed, 14 Apr 2010 11:42:21 >>>> To: <[email protected]> >>>> Subject: Re: Extracting digits from a character field >>>> >>>> Jim, >>>> >>>> Just curious.. What are the limitations that you encountered replacing a >>>> character or a string with NULL on MS-SQL.. And what version of MS-SQL?? >>>> >>>> Joe >>>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> [mailto:[email protected]]on Behalf Of Jim Fox >>>> Sent: Wednesday, April 14, 2010 11:12 AM >>>> To: [email protected] >>>> Subject: Re: Extracting digits from a character field >>>> >>>> >>>> On MS-SQL, trying to replace one character with Null is not a good idea. >>>> >>>> Fluxman >>>> ------Original Message------ >>>> From: Joe D'Souza >>>> Sender: Action Request System discussion list(ARSList) >>>> To: [email protected] >>>> ReplyTo: [email protected] >>>> Sent: Apr 14, 2010 11:07 >>>> Subject: Re: Extracting digits from a character field >>>> >>>> If you are in an Oracle database, use the function TRANSLATE to replace >>>> all >>>> Alpha characters with either NULL or space or whatever else you wish >>>> to.. >>>> This will leave the string with only special characters and numerical >>>> characters.. >>>> >>>> I am not sure if TRANSLATE works on MS-SQL but you could give it a shot >>>> if >>>> MS-SQL is your underlying database. >>>> >>>> Joe >>>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> [mailto:[email protected]]on Behalf Of Atul Vohra >>>> Sent: Wednesday, April 14, 2010 9:42 AM >>>> To: [email protected] >>>> Subject: Extracting digits from a character field >>>> >>>> >>>> I have a free form character field and need to extract digits from that >>>> field - may be in a filter? Am on v7.1, oracle. >>>> >>>> Any one has some function they used (like in sql or may be combination >>>> of >>>> strstr??) Looks painful to me. >>>> >>>> Help please >>>> >>>> Atul >>>> >>>> >>>> _______________________________________________________________________________ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >>>> >>> >>> >> > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
