Find part of a string with regular expression in a given string

Hello, I have a test where I need to create filters with text using logical operators as below. In the results it returns all the matching records. I am not getting any idea how to test this with Te...