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" <remedyiss...@gmail.com> 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"