Filter a data table if contains

Help
21

Yes…

22

(DataTable.Select(“Key LIKE ‘%PendingBotCSV%’”).CopyToDataTable())

23

Check this out:
datatable.Select(“[column name] = ‘OK’”)

24

Hello All,
Kindly suggest me on similar issue. I am using as below.

image

My target is ==>
excel sheet must filter the data with below options:

  1. Only Resolved ==> Successful tickets
  2. Type NOT EQUAL != Service Bulletins
  3. Casetype NOT EQUAL To != Problem
  4. All requester login ids ==> must be UNIQUE
  5. Remove special character ==> () from all cloumts , If any.

Regards,
Santhoshi GV

25

Hi Rahul,

I want to filter a single column for 2 values and also have to apply 2 filters on two different columns as well? But somehow by using this activity I am unable to get the desired result.

Do you have a workaround for the same?

26

Hi,

That can be done using linq query without filter option.

27

I did it using or itself, thanks anyway.

28

How can you achieve the same results for the query below if you have a list of possible strings to allow?
dt.Select(“result LIKE ‘%ok%’”)
list = “ok, okay, ready”

I know it won’t work using LIKE