Its what I use to dynamicall format phone numbers on the fly.
On Thu, Apr 15, 2010 at 5:39 PM, cpgold <cpg...@gmail.com> 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 <cpg...@gmail.com> 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 <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"
