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"
