The wildcard(s) in a LIKE statement are on the right side of the LIKE.
Since you have to deal with multiple values in the CC field, what you
will have to do is to loop thru the $CC list$ field and parse the values
into a temp Display Only field and compare the temp field with the
mailing list field. Something like ...
1. Set TempField1 = $CC list$
2. if TempField1 contains a Return (line feed)
grab the value up to the Carriage Return and put it in TempField2
remove TempField2 (including the Carriage Return) data from
TempField1
else
set TempField2 = TempField1
set TempField1 = $NULL$
3. compare $Field B$ to TempField2 ( $Field B$ LIKE (("%" +
$TempField2$) + "%") )
do what you need to if the data is in Temp B
4. if TempField1 != $NULL$ ( more values to check)
goto 2
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 05, 2007 9:19 AM
To: [email protected]
Subject: Re: how to read the whole content of a drop-down menu
well if I try $CC list$ = $Field B$ that works but if try (("%" + $CC
list$ ) + "%") LIKE $Field B$ that doesn't work.
My guess is that $CC list$ contains one string per line.
So my concern now is how to make this field be red as one string. The
$PROCESS$ of course doesn't work on the web.
Any help ?
Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
> Yes, it should work. If you format the LIKE statement correctly, it
> should work.
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour
> Sent: Wednesday, September 05, 2007 8:16 AM
> To: [email protected]
> Subject: Re: how to read the whole content of a drop-down menu
>
> many thanks for this feedback. I believe it will most probably work
this
>
> way.
> How ever, I am working on something pretty close to this idea. And I
am
> encountering a problem which I believe I will also have when trying
your
>
> solution.
> It is the following:
> in the field where users type in, they insert email addresses. They do
> so by typing each email address on a new line. And at the moment what
I
> don't get the Remedy do is to compare correctly something like (("%" +
> $CC list$) + "%") with the $mailing-list$ field.
> That doesn't simply work. I am wondering whether this is my mistake
> somewhere or this because of the every line on my original field ?!?
> Will it work correctly with the solution you are giving ??
> ...
> Serouche
>
>
>
>
> Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
>
>> Does this have to stay as a file? If not, save a copy of the file as
a
>> CSV. Then create a new support form with one field on it. Call that
>> field "Email" or whatever you want. Use the import tool to import
the
>> email addresses in the file (which is now a CSV) into the form. Now
>>
> you
>
>> have one Remedy record for every entry in the file.
>>
>> Now just automate what you want to do with workflow. Put a hidden
>>
> field
>
>> under your character field on form B, and on Submit (or whatever
event
>> you want), do a SET FIELDS. Set the hidden field if...
>>
>> Character Field on Form B = Record in New Form You Just Created
>>
>> Then have a second active link that throws an error if the hidden
>>
> field
>
>> is not null.
>>
>> -----Original Message-----
>> From: Action Request System discussion list(ARSList)
>> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour
>> Sent: Wednesday, September 05, 2007 7:54 AM
>> To: [email protected]
>> Subject: Re: how to read the whole content of a drop-down menu
>>
>> what I mean is that Remedy users type in what they are by policy not
>> allowed to type i.e mailing-lists
>> these mailing-lists are in a file outside the Remedy
>> so my problem is: how can I make the Remedy read the file, compare
the
>>
>
>
>> content with what people type. And every time a user type in
something
>>
>
>
>> which is found in that file, the Remedy should say "error guy !"
>> The file is about 900 lines with one value per line. Of course I
could
>>
>
>
>> change the format of the file (still being always on my Unix box).
>> The field where people type in is a character field.
>> Any help ?
>>
>>
>>
>> Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
>>
>>
>>> What do you mean by "...bounce people from adding mailing-lists into
>>> the CC list field"? Do you mean you want to force people to use the
>>> values as presented in the menu and prevent them from typing stuff
>>>
> in?
>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour
>>> Sent: Wednesday, September 05, 2007 2:43 AM
>>> To: [email protected]
>>> Subject: Re: how to read the whole content of a drop-down menu
>>>
>>> maybe I shall give more details on my problem and the situation:
>>> I have a file with a list of mailing-lists
>>> I have created a form (A) with one character field which reads the
>>>
>>>
>> file
>>
>>
>>> and displays it as a menu
>>> I have another form (B) with a character field where people add
>>>
> emails
>
>>>
>>>
>>
>>
>>> (CC list).
>>> What I'd like to do is to bounce people from adding mailing-lists
>>>
> into
>
>>>
>>>
>>
>>
>>> the CC list field. :-)
>>> ...
>>> I can't get it :-(
>>> ...
>>> any help ?
>>> Thanks
>>> Serouche
>>>
>>>
>>> Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
>>>
>>>
>>>
>>>> Or better yet, create a form specifically for the menu items and
>>>>
> then
>
>>>> importing the items from the file into the form? Then field
>>>>
>>>>
>> validation
>>
>>
>>>> is extremely easy...and you don't have nitnoid separate files to
>>>> maintain.
>>>>
>>>> -----Original Message-----
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser
>>>> Sent: Tuesday, September 04, 2007 12:24 PM
>>>> To: [email protected]
>>>> Subject: Re: how to read the whole content of a drop-down menu
>>>>
>>>> **
>>>> Have you tried pulling the file that your menu reads from into an
>>>> unlimited length, display only field and then using string
functions
>>>> (such as STRSTR) to find if the value entered is in the list?
>>>>
>>>> If that doesn't work maybe a run process utilizing grep or find?
>>>>
>>>> Thad Esser
>>>> Remedy Developer
>>>> "Argue for your limitations, and sure enough, they're yours."--
>>>>
>>>>
>>>>
>>> Richard
>>>
>>>
>>>
>>>> Bach
>>>>
>>>>
>>>>
>>>> "Serouche Rahimpour" <[EMAIL PROTECTED]>
>>>> Sent by: "Action Request System discussion list(ARSList)"
>>>> <[email protected]>
>>>>
>>>> 09/04/2007 08:33 AM
>>>> Please respond to
>>>> [email protected]
>>>>
>>>> To
>>>> [email protected]
>>>> cc
>>>> Subject
>>>> Re: how to read the whole content of a drop-down menu
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> I just tried with $MENU$ and the browser (because it has to be on
>>>>
> the
>
>>>>
>>>>
>>
>>
>>>> web) returns $MENU$ in the field.
>>>> I checked afterwards in the Admin tool. It has corrected $MENU$ for
>>>> "$MENU$"
>>>> Another idea ?
>>>>
>>>>
>>>> Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
>>>>
>>>>
>>>>
>>>>
>>>>> I'm not sure if it works with menus built from external files, but
>>>>>
>>>>>
>>>>>
>>>>>
>>>> have
>>>>
>>>>
>>>>
>>>>
>>>>> you tried $MENU$?
>>>>>
>>>>> -----Original Message-----
>>>>> From: Action Request System discussion list(ARSList)
>>>>> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour
>>>>> Sent: Tuesday, September 04, 2007 10:19 AM
>>>>> To: [email protected]
>>>>> Subject: how to read the whole content of a drop-down menu
>>>>>
>>>>> hi,
>>>>>
>>>>> let say I have a drop-down menu which values come from a Menu
which
>>>>>
>
>
>>>>> reads itself from a file.
>>>>> Let say on another form I have a character field and I want to
>>>>>
> check
>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> the
>>>>
>>>>
>>>>
>>>>
>>>>> content of this field (what users type in) is or is not in the
>>>>>
>>>>>
>>>>>
>>>>>
>>>> drop-down
>>>>
>>>>
>>>>
>>>>
>>>>> menu.
>>>>> I tried with different filters and AL but each time I am not able
>>>>>
> to
>
>>>>>
>>>>>
>>
>>
>>>>> read the whole list (about 900 entries in the drop-down list.)
>>>>> Any idea/help/questions?
>>>>> Many thanks.
>>>>> Cheers
>>>>> Serouche
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>
________________________________________________________________________
>
>>
>>
>>>
>>>
>>>
>>>>
>>>>
>>>>
>>>>
>>>>> _______
>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>> ARSlist:"Where
>>>>
>>>>
>>>>
>>>>
>>>>> the Answers Are"
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>
________________________________________________________________________
>
>>
>>
>>>
>>>
>>>
>>>> _______
>>>>
>>>>
>>>>
>>>>
>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>>
>>>>>
>>>>>
>>>>>
>>>> ARSlist:"Where the Answers Are"
>>>>
>>>>
>>>>
>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>
________________________________________________________________________
>
>>
>>
>>>
>>>
>>>
>>>> _______
>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>
>>>>
>>>>
>>> ARSlist:"Where
>>>
>>>
>>>
>>>> the Answers Are"
>>>>
>>>>
>>>>
>>>>
>>>> ***IMPORTANT NOTICE: This communication, including any attachment,
>>>> contains information that may be confidential or privileged, and is
>>>> intended solely for the entity or individual to whom it is
>>>>
> addressed.
>
>>>>
>>>>
>>>>
>>> If
>>>
>>>
>>>
>>>> you are not the intended recipient, you should delete this message
>>>>
>>>>
>> and
>>
>>
>>>> are hereby notified that any disclosure, copying, or distribution
of
>>>> this message is strictly prohibited. Nothing in this email,
>>>>
> including
>
>>>> any attachment, is intended to be a legally binding signature.***
>>>>
>>>>
>>>> __20060125_______________________This posting was submitted with
>>>>
> HTML
>
>>>>
>>>>
>>>>
>>> in
>>>
>>>
>>>
>>>> it___
>>>>
>>>>
>>>>
>>>>
>>>>
>
________________________________________________________________________
>
>>
>>
>>> _______
>>>
>>>
>>>
>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>>
>>>>
>>>>
>>> ARSlist:"Where the Answers Are"
>>>
>>>
>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>
________________________________________________________________________
>
>>
>>
>>> _______
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>
>>>
>> ARSlist:"Where
>>
>>
>>> the Answers Are"
>>>
>>>
>>>
>>>
>
________________________________________________________________________
>
>> _______
>>
>>
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>
>>>
>> ARSlist:"Where the Answers Are"
>>
>>
>>>
>>>
>>>
>>
>
________________________________________________________________________
>
>> _______
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>
> ARSlist:"Where
>
>> the Answers Are"
>>
>>
>>
>
________________________________________________________________________
> _______
>
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>
> ARSlist:"Where the Answers Are"
>
>>
>>
>
>
________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where
> the Answers Are"
>
>
________________________________________________________________________
_______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"
>
>
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
