I have the following business case:
I load an excel sheet containing two columns (email and subject) in a table.
When I receive an email I need to check
- If the sender exists in the table
- If the subject related to the sender has the correct format
Then I can move on.
The problem is with the subject comparison. The pattern (loaded from the excel to the table) is like
’My name is Dimitrios and I try to make it work’
The email subject may contain anything instead of Dimitrios, but must start and end with the same way as the pattern.
One more thing: The pattern is not the same, there are different patterns in the table and I need to check every email against all of them.
My thought is that changing the excel structure containing 3 columns (email, start pattern, end pattern) and checking the if email subject starts with and end with those patterns will make my life easier, but I know almost nothing about RegEx.
Is there a way to use Text actions in combination with RegEx to achieve this easier and faster?
Any input/ideas is much appreciated.