Hi,
I think this has a little to do with the DBMS you are using. Sybase and
MS-SQL should work with the following syntax, where the character "_"
matches exactly one character, and the [^+] matches anything but "+".
LIKE "_%+%_" would require at least one character before and after the +.
You should also be able to use the "[^+]%+%[^+]" to make sure that you
have something other than + at the beginning and end of the field.
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.
> 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"
>
> --
> 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] ARSlist: "Where the Answers Are"
