Dt.select using like

Help
1

I want to select text which is having both the words text DD and Rejected.
I am having text

  1. 0SEP DD CDTR REJECTED?20
  2. 00SEP DD CDTR CORE 20
    3)SE Rejected Ba
    How to select this using dt.select(“text Like pattern”).
    help me with this pattern.
2

dtFiltered = DT.Select( “text like ‘%DD%’ AND text like ‘%Rejected%’”)

1 Like
3

Hi @Jesi

Try below codes

It will return datarow[] → datarow array.
Filteredrow= DT.Select("text like '%DD%' AND text like '%Rejected%'")
Below code will return as datatable.
Filtereddatatable = DT.Select("text like '%DD%' AND text like '%Rejected%'").CopyToDataTable()

Regards,
Arivu

6 Likes
4

can you please share a sample workflow?

5

Hi @Akhil,

you can directly use assign activity to filter the data.

Regards,
Arivu :slight_smile:

1 Like
6

Do i need to import any library or packages?
I’m getting error like - cannot find column [text]

7

HI @Akhil,
“text” is column name of the data table.

and “DD” is value of the column

In your data table doesn’t have text column, that’s why thrown exception.

Main (6).xaml (9.0 KB)

Regards,
Arivu

2 Likes
8

@arivu96 Thanks for the solution :+1::+1:

9

can we select particular row if column is empty using dt.select(“column Like pattern ”)
help me with this pattern

10

Hi @Jesi
Yes you can,
DtFilteredRow=dt.select("column =''")

Regards,
Arivu :slight_smile:

2 Likes
11

image

2 Likes
12

When I use dt.Select(“[ColumnName] LIKE ‘%String%’”) I met the error is: Can’t use LIKE operator to System.Double and System.String.
How can I fix them?
Helpme please!

1 Like