Similar node to if(isnumber(find) in excel

[mh_elhassan]

Hello community,
I need a node or a method which is equivalent to the IF(ISNUMBER(FIND(“Samsung”,F4)),“Samsung”,“Else”)
However. i ll need to do it for every brand.

[elsamuel]

You can use the Rule Engine or Column Expressions node.

Assuming all the brands are in a column called Brand, then

the Rule Engine node would be configured with an expression such as

$Brand$ LIKE "Samsung" => "Samsung"
TRUE => "Else"

and the Column Expressions node would be configured with an expression such as:

if (contains(column("Brand"),"Samsung") == true)
{"Samsung"}
else
{"Else"}

[mh_elhassan]

oh thank you. i don t know why i couldn’t think of it

[mh_elhassan]

I have just tried now, and it is not working. it returns only else

[elsamuel]

I have just tried now, and it is not working. it returns only else

This is not very informative. I gave 2 options - what exactly is it that you tried? Did you modify the expressions in any way?

It would be best if you shared the workflow so we can see how you configured the nodes.

[mlauber71]

@elsamuel

$Brand$ LIKE "Samsung" => "Samsung"

I think this would need “*”:

$Brand$ LIKE "*Samsung*" => "Samsung"

[mh_elhassan]

thanks a lot it is working now

[mh_elhassan]

i used the rule engine. thanks again
@mlauber71 thanks