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 <jdso...@shyle.net> 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:arsl...@arslist.org]on Behalf Of Jim Fox
> Sent: Wednesday, April 14, 2010 2:03 PM
> To: arslist@ARSLIST.ORG
> 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 <jdso...@shyle.net>
> Date: Wed, 14 Apr 2010 13:25:31
> To: <arslist@ARSLIST.ORG>
> 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:arsl...@arslist.org]on Behalf Of Jim Fox
> Sent: Wednesday, April 14, 2010 1:00 PM
> To: arslist@ARSLIST.ORG
> 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 <jdso...@shyle.net>
> Date: Wed, 14 Apr 2010 11:42:21
> To: <arslist@ARSLIST.ORG>
> 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:arsl...@arslist.org]on Behalf Of Jim Fox
> Sent: Wednesday, April 14, 2010 11:12 AM
> To: arslist@ARSLIST.ORG
> 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: arslist@ARSLIST.ORG
> ReplyTo: arslist@ARSLIST.ORG
> 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:arsl...@arslist.org]on Behalf Of Atul Vohra
> Sent: Wednesday, April 14, 2010 9:42 AM
> To: arslist@ARSLIST.ORG
> 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"
