NEED TO FIND A PARTICULAR LETTER IN EXCEL

Help
1

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
2

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

3

Thanks for your immediate response with step by step solutions,lets i try it…

1 Like
4

Great
Cheers @AMALRAJ

1 Like
5

so any issues to be discussed further
Cheers @AMALRAJ