Remove row from a particular string from data Table

[Veera_Raj (Veeraraj Sethuraman)]

can you give some dummy data for develop the code ?

[taruna.mehra (Taruna Rishu Mehra)]

just take any excel and mention any random name in that excel.

then make a bot which is removing the complete where that random is coming.

[Veera_Raj (Veeraraj Sethuraman)]

you want to remove complete row or just that particular string ?

[taruna.mehra (Taruna Rishu Mehra)]

complete row.

[taruna.mehra (Taruna Rishu Mehra)]

what does it means, kindly explain me.

[jack.chan]

@taruna.mehra

Data Table String removal

use this instead sorry @taruna.mehra logic: loop table in reverse, for each row look through all columns and find the strToFind, if found delete the row exampleemail.xaml (14.0 KB) test.xlsx (12.7 KB) example (strToFind = “delete”) [image] result (result sheet) [image]