Excel - IF Activity - Condition based on specific word

[DadouSan]

Hi everyone.

I am trying to separe Excel data depending on a specific word.

I know I can use a filter activity to achieve the same result, but I want to create it with an IF activity using the condition ???.Contains(“Specific Word”). Then/Else. (As shown on the screenshot).

But I don’t know what I am suppose to write in the ??? to be able to use .Contains

Thank by advance for any help provided.

[Arpit_Kesharwani]

@DadouSan you need to use row(“ColumnName”).ToString.Contains(“Specific word”) OR row(coloumnIndex).ToString.Contains(“Specific word”)

[DadouSan]

Thanks, working perfectly.