Hi,
You say VALIDATE which seems to indicate that you are running filters in Form A
on a transaction, and you need to validate that the last word of field A can be
found in Form B. Right?
In that case I would suggest that you parse out the last word of the field in
Form B and store "DEF" in a separate field of Form B called
'LastWordFormB-Field'.
You then perform the same operation on Form A during your transaction and store
the last word in form A in a temp-field. Then you search for
('LastWordFormB-Field' = $temp-field$)
You do not even need a LIKE operation.
If you do not want to store the last word you will validate from, you can skip
that part and instead do this search:
'FormB-Field' LIKE "%" + $temp-field$
But you will have to parse out the last part of the string before running a
search. Like will not do this for you.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* 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
November 7, 2016 7:54 PM, "Kaur" wrote:
> Hi all,
>
> I need to write a qualification to validate a field in form A against a field
> in form B using "%"
> and LIKE.The qualification I have written is
>
> $fieldA$ LIKE "%"+'fieldB'+"%" , where
>
> fieldA- field in form A
> fieldB -field in form B
>
> fieldA= ABC DEF
> fieldB= XYZ DEF
>
> I need to do a partial search on the basis of 'DEF'
>
> Please help me in solving this.
>
> Thanks!!
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
