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"
