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
Did it worked buddy?
You could use select query.
Follow url for reference
yes bro …thank u