i am a beginner of Uipath I m having a excel sheet with lot of words with contains q letter in a column,i need to write in a another column"the word contains q " or otherwise the word doesn’t contains q"
for example:
" unquenchable" contains q
“moonlight” doesn’t contains q
“query” contains q likewise
1 Like
Hi
Welcome back to uipath community
Hope these steps could help your resolve this
— use a excel application scope and the file path as input
—use a read range activity and get the output with a variable of type datatable named outdt
—use a for each row loop and pass the above variable as input
—inside the for each loop use a if condition like this
row(“yourcolumnname”).ToString.Contains(“q”)
If the condition pass it will go to aThen Part where we can use assign to mention in another column like this
row(“yourcolumnname”)=“the word Contains q”
Cheers @AMALRAJ
Thanks for your immediate response with step by step solutions,lets i try it…
1 Like