Anyone have a good method for doing substring matches where field1 is my searched field and field2 is my substring I want to search for? Attempted to use the following logic without any luck and running low on ideas. | eval comparison = if(like(field1, %field2%), "1", "0") field1 is a URL and field2 is a base domain, but field2 is input from a lookup, so it's variable but would look something like: field1="http://www.yahoo.com/mail/inbox"
field2="yahoo"
OR
field1="linkedin.com/company/google/profile"
field2="google" I'm low on ideas after spending my time in docs and forums all day.
... View more