Excel - IF Activity - Condition based on specific word

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.

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

2 Likes

Thanks, working perfectly.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.