06-24-2014 08:51 PM
I am trying to filter out records with the word "PAY" in the description but I want to filter out words containing PAY.
So for example if the description says
JOHN SMITH WEEKLY PAY
Then I wish to include this record as the word PAY is by itself. However if the Description is in the form of
PAYPAL , BPAY, PAYED
or any characters or words that start, has pay in the middle or ends with pay, then I wish to exclude the record.
Is there anyway to be able to do this?
06-24-2014 09:19 PM
if findw(name,'PAY')>0 then output;
06-25-2014 09:04 AM
OR perl regular expression :
if prxmatch('/\bPAY\b /',name) ;