I have an xml file with a text field. The text field may include trigger words. I have a list of those trigger words. Obviously I can search for those trigger words from the text field by using wildcards. I don't want to do sub-searches for every possible correlation.
So my description might be "item rejected because expiration date is wrong" or "security violation" or "date of birth missing, application rejected" and my keywords might be "rejected", "expiration", "security", or "violation".
Is there a way to do a lookup using the wildcard by way of substitution? Would you use a regex?
I'd like to be able to group the results by trigger word.