Can I write a CSV Lookup that's Partial Matching?

[pagnihot]

Dear All

I have a CSV lookup with a column name column1 with below values

MicroBest

GoDear

Bear

And I have some logs in which the field1 contains values like

MicroBest Infrastructure

No-GoDear-To-World

Lives The Life

I want to write a query that should match the first two events as lookup column value is a substring to field value. Also, I don't want to use *lookup_value* as it will also match something like Mi GoDearSamsung-Phone.

I

[ITWhisperer]

You can use WILDCARD matching in your lookup definition. This would require the csv to have the wildcarding in, e.g. *GoDear*, however, this does help you in your case because you haven't provided a way to distinguish between No-GoDear-To-World and Mi GoDearSamsung-Phone, such that one would match and the other not match.