How to Use Select Method

So i have scraped Invoice from Acme Website and now i want to use Select(Filter) to get the invoice of data Greater than 7-1-2018 so how do i use select to only get the above given condition

Thanks in Advance

Hi @vickydas

See these

Thanks,
Prankur

2 Likes

Hello @PrankurJoshi first of all thank you for helping me below is a screenshot of my workflow please see what kind of error i am getting which is mentioned below

Quotes are wrong in second condition.

1 Like

Okay then what is the correct syntax.what is the correct placement of those quotes ?

Try this

dt.Select("[InvoiceItem]='IT Support' AND Date > '2017-01-08'").CopyToDataTable

Or this

dt.AsEnumerable().Where(Function(r) r("InvoiceItem").Equals("IT Support") AND cDATE(r("Date")).ToString("yyyy-mm-dd") > CDate("2017-08-01").ToString("yyyy-mm-dd")).CopyToDataTable

Or even this

(From p In dt.Select
Where "IT Support".Equals(p.Item("InvoiceItem")) And CDate(p.Item("Date")).ToString("yyyy-mm-dd") > CDate("2017-08-01").ToString("yyyy-mm-dd")
Select p).CopyToDataTable

Thanks,
Prankur

9 Likes

@PrankurJoshi solved my problem thank you for your help

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.