How to filter the string

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

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

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

Can u show the column as screenshot?

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

thank u

Did it worked buddy?

1 Like

Hey :smiley:

You could use select query.

Follow url for reference

yes bro …thank u

1 Like