Thanks Frank.
From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Monday, November 30, 2009 3:47 PM To: arslist@ARSLIST.ORG Subject: Re: Need to search values with special characters ** Like "%[0-9]++[0-9]%" The above will give you the middle result only. Also, Like "%[0-9,a-z]++[a-z,0-9]%" If the string contains alphanumeric vlaues. The 7.1 Workflow Objects doc contains a good write up on wildcard searching On Mon, Nov 30, 2009 at 12:16 PM, Vani Masilamani <va...@virtusa.com> wrote: Hi All, Is there a way to find out a character(example "+") is present in the middle alone leaving the first and last in the value. For example, 1. ++5501, 2. 55++01 3. 5501++ I could write ( 'Validation check' LIKE "%+" ) for the last representation - will result 3 I could write ( 'Validation check' LIKE "+%" ) for the first representation - will result 1 Can get a qualification for the middle one, it should not consider the above two? Thanks, Vani -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Vani Masilamani Sent: Friday, November 27, 2009 4:28 PM To: arslist@ARSLIST.ORG Subject: Re: Need to search values with special characters Thank a lot Misi. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Friday, November 27, 2009 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Need to search values with special characters Hi, Use "" to match a ", and [%] to match a %. For example ('F' LIKE "%""%") or ('F' LIKE "%[%]%"). Best Regards - Misi, RRR AB, http://www.rrr.se <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. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se <http://rrr.se/> . > Hi All, > > > > Can anyone of you give an idea to use the special characters(",%,_) in > Remedy at run if qualification for a field check. > > > > Example : I need to get the below values when I use a like operator. > > > > 7453%8, 7_890, ab"cd > > > > Thanks, > > Vani. > > > ------------------------------------------------------------------------ --------------------- > > This message, including any attachments, contains confidential information > intended for a specific individual and purpose, and is intended for the > addressee only. Any unauthorized disclosure, use, dissemination, copying, > or distribution of this message or any of its attachments or the > information contained in this e-mail, or the taking of any action based on > it, is strictly prohibited. If you are not the intended recipient, please > notify the sender immediately by return e-mail and delete this message. > > ------------------------------------------------------------------------ --------------------- > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> > Platinum Sponsor:rmisoluti...@verizon.net <mailto:sponsor%3armisoluti...@verizon.net> 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 <http://www.arslist.org/> Platinum Sponsor:rmisoluti...@verizon.net <mailto:sponsor%3armisoluti...@verizon.net> ARSlist: "Where the Answers Are" ------------------------------------------------------------------------ --------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ------------------------------------------------------------------------ --------------------- ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor:rmisoluti...@verizon.net <mailto:sponsor%3armisoluti...@verizon.net> ARSlist: "Where the Answers Are" ------------------------------------------------------------------------ --------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ------------------------------------------------------------------------ --------------------- ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor:rmisoluti...@verizon.net <mailto:sponsor%3armisoluti...@verizon.net> ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ --------------------------------------------------------------------------------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. --------------------------------------------------------------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"