Hi,
We have seen both direct-sql-approaches and java-script-approaches.
Please use the built in functionality if at all possible.
If you start using external things, your system will soon become
unmanageable.
1. You will get a system that is database-vendor-dependent or dependent on
some other external technology
2. You will get a system that can not be understood and/or debugged using
AR System tools only
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
