Filter particular column only numeric and remove Empty row

Help Studio
, ,
1

Hi,
i have excel file in that Particular Column Name is Assignment column have to filter

  1. filter only numeric values
    2.remove empty row
  2. save into new sheet

image

How to do it ? can any one help ?
Filter.xlsx (9.2 KB)

2

Hi

Hope this expression would help you resolve this

dt = dt.AsEnumerable().Where(Function(a) Isnumeric(a.Field(of String)(“Assignment”).ToString) AND NOT String.IsNullOrEmpty(a.Field(Of String)(“Assignemnt”).ToString.Trim)).CopyToDatatable()

Cheers @Anand_Designer

3

in Addition to

Use a LINQ within assign activity
left: Result | Datatype: List(Of Datarow)
right:

(From d in dtData.AsEnumerable
Let v = d("Assignment")
Where Not ( isNothing(v) OrElse String.IsNullorEmpty(v.toString.Trim) )
Where Regex.IsMatch(v.ToString, "^\d+$")
Select r = d).toList

then check within an if acitvity
Result.Count > 0
Then: dtResult = Result.CopyToDataTable
Else: dtResult = dtData.Clone

We do use this defensive approach as an empty filter result let CopyToDataTable will throw an Exception. So we use the copytodatable only when the filter result has some rows

Ensure following:

grafik
grafik241×161 18 KB

4

Getting Error used DT As datatable variable

image
image1210×614 29.5 KB

5

can you give example

6

You didn’t close after .ToString while checking Isnumeric

Exactly here

Check this expression again

Cheers @Anand_Designer

7

have a look above on the detailed description

8

still getting error

FilterAsiignment.xaml (6.9 KB)

9

grafik
grafik791×384 40.1 KB

find starter help:
FilterAsiignment_V2.xaml (8.3 KB)

10

@ppr Thank you for given a solution