Compare the data in notepad and data table

Help
1

My notepad data is

orange oranges apple jack fruit water melon

My data table contains
orange
apple
jack fruit

if the data matches , some process need to be done.

I am struggling in this comparison itself, because the datas are more than 30 . So i cant use 30 if conditions. and switch is also not working for this .
Guys please help!!!

1 Like
2

Fine keep all the data you want to check with excel --in a array string like this
in_strarray = {"orange ",“oranges “,“apple “,“jackfruit”,“watermelon”,””,””}

and in the excel
-use a excel application scope and pass the file path as input
–use read range activity and get the output with a variable of type datatable
and name it outdt
–use a for each row loop and pass the above variable as input
–inside the for each row loop use a if condition like this
in_strarray.Contains(row(“yourcolumnname”).ToString)
if true means will goto THEN part where we can have any activity we want or will goto ELSE part and include activities there accordingly

Hope this would help you
Kindly try this and let know for any queries or clarfication
Cheers @Rachel

3

i cant split the string, as the delimiter is not constant.Sometime it will be single space, sometimes double space.
That is the issue