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 <[email protected]> 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:[email protected]] On Behalf Of Vani Masilamani > Sent: Friday, November 27, 2009 4:28 PM > To: [email protected] > Subject: Re: Need to search values with special characters > > Thank a lot Misi. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Misi Mladoniczky > Sent: Friday, November 27, 2009 3:23 PM > To: [email protected] > 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 > > 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. > > > 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 > > Platinum > > Sponsor:[email protected]<sponsor%[email protected]>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 > Platinum > Sponsor:[email protected]<sponsor%[email protected]>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:[email protected]<sponsor%[email protected]>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:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
