Delete row which contain comma

i want to del that row which contain comma
so i ahve used switch condition and if its true i have used delete row

what to write in position and noofrows

@Ananya1 Can you explain in a Little more detail what you are doing ? :sweat_smile:

we can do that with a assign activity like this
dt = dt.AsEnumerable().Where(Function(a) NOT a.Field(of string)(“yourcolumnname”).ToString.Contains(“,”)).CopyToDatatable()

now this datatable dt will have rows without comma in a specific column

Cheers @Ananya1

1 Like