Match db and multiline input

Hello, little puzzle on a formula:
I have a multiline input in which I describe a product “Car Renault”
I want to extract the brand knowing that I have a database with all the brands.
So I do a search “Search for brand” with constraint brand name contain multiline input value but it doesn’t work, I tried to add a “split by space” but no more. He doesn’t understand because he’s looking for a brand with the name “car, Renault”, you have to do an or between each word but I can’t find the appropriate function.
If I mark only Renault it manages to match but not with an additional word, do you have any idea?

You can use contains or contains keyword(s) operators. Read about the difference here.

This topic was automatically closed after 70 days. New replies are no longer allowed.