Search In Excel Data Table using linq

Help Studio
, ,
3

@Anil_G

If I need to use filter data table in Linq , I am having one challenge .

Before I use filter data table for column values “Charges” and “ListPrice(Quantity)”

The image shows a snippet of a workflow from UiPath involving a conditional "Else" statement, where an "Assign" activity is used to filter a DataTable based on a regular expression matching the "List price (Quantity)" column. (Captioned by AI)
The image shows a snippet of a workflow from UiPath involving a conditional "Else" statement, where an "Assign" activity is used to filter a DataTable based on a regular expression matching the "List price (Quantity)" column. (Captioned by AI)818×225 41.4 KB

I first need to use the regex expression for “ListPrice(Quantity)” column to remove $ and USD and then use filter data table. Can I achieve all this in Linq Expressions. first regex expression for column ListPrice(Quantity) Regex expression and then filter data table to compare? I am unable to get the Linq expressions

“\d+.\d{2}\d*(?<=[1-9])|\d+.\d{2}”)

Like apply regex to column “List price (Quantity)” column and then use filter data table query to compare the column values

if column value List price (Quantity) =ListPrice (queue item) AND “Charges” = SkuName

THEN do nothing else add queue item