How to filter the string

Help
, ,
1

which activity i can use to filter string in a loop the from excel table

2

U can use filter datatable activity to filter the datatable based on columns

3

not colums actually , for example if a particular column in a table contains full names of a customer ,how i can filter it to only for first name

4

Can u show the column as screenshot?

5

2
2743×249 10.8 KB

6

First read the excel file using read range and store in dt1

Then use the below linq query

dt1.AsEnumerable().Where(Function (row) row(ColumnName).ToString.Contains(System.Text.RegularExpressions.Regex.Match(“[A-z]+\s”, row(ColumnName).ToString).Value).CopyToDataTable

7

thank u

8

Did it worked buddy?

1 Like
9

Hey :smiley:

You could use select query.

Follow url for reference

10

yes bro …thank u

1 Like