Hi All,
I want a small help where in I want to search a column for 2 words and if both words are present then execute an if statement else execute the other part.
For example, if I have 2 strings in a column: Input1:Hello.everyone.how.are.you
Input2:Hello.all.how.are.you
then if "Input1" and "Every" is present in a single row of a column, the output should be 1. So for the first string output should be 1 and for the second one output should be 0.
Thank you in advance.