I’m looking for ideas to automate the following process:
We have a report of all expense claims made by our employees, we would like to search for keywords in the comments of these claims. If a keyword is found, then we need the value in the next column to decide what action to take.
This is what the keyword file would look like:
This is what the comments could be:
If no keywords have been found, then the claim is OK and we don’t need to do anything.
If a keyword has been found, then we need to make a queue item for it with the value of ‘Action’. (And a lot of other transactiondata)
I’m having trouble to come to ideas for this. I’m wondering what you guys think.
How to search all the keywords in a comment? Regardless if its with an upper or lowercase for example.
Thanks in advance,