Data Table - Select row

[Brano (Branislav)]

I scrape data with data scraping and I need filter or count rows.I know how I can count row when I count year(Str.), ExtractDataTable.Select(“[Poistený Meno/IČO] = '”+ICO+“’ and [Dát.vzniku] like '%”+(CInt(Yearinput)-4).ToString+“'”) this works perfect, but I have problem when I need know how many rows is 01.01.2014 ago.This syntax doesn’t work ExtractDataTable.Select(“[Poistený Meno/IČO] = '”+ICO+“’ and [Dát.vzniku] <'”+DateTime+“'”), DateTime=01.01.2014.

Thanks
B

[Vivek_Arunagiri]

Check the below post.

How to select data table with date format when I read range to Excel?

Hi all, Does anybody know how to simple way how to extract data table items from the table that was read from Excel file? In my case, there is 3 column in a Excel, ID, Name and DateTime, for example. And when I read it with Read-range activity, all data will be read as String format and I cannot use Datatable.select activity with date time fo-rmat. (Like Datetime < now() - 1 day.) Indeed, it is able to separate data if I use for each row and convert string to Datetime format but I think it mi…

[Divyashreem (Divyashree Muddagangaiah)]

Select Returns No Row When There Is An Empty Value in Select Column

Scenario: Hello, I want to take all rows from Excel data only where the “Access Date” Column is today. This is my code: dt1.Select(string.Format(“[Access Date] = '”+todayDate+“'”)) where todayDate was “2018/01/25”. Problem: This works fine with Data 1 (returned 1 row), but not with Data 2 (return 0 row). Data 1: [Data1] Data 2 (notice Data 2 has some rows with empty Access Date): [Data2] Question Could anyone suggest me: Why this happened? How to handle this? Attached: Sample .xam…

[Brano (Branislav)]

I check this post, but I have still problem.I use this select ****(From p In ExtractDataTable.Select()
Where Convert.ToDateTime((p.Item(“Dát.vzniku”)))<DateTime Select p).ToArray.CopyToDataTable with this error Assign : String was not recognized as a valid DateTime.
Dát.vzniku(Str) format is. “23.11.2015”
Thanks

[Vivek_Arunagiri]

Please try.

select ****(From p In ExtractDataTable.Select()
Where Convert.ToDateTime((p.Item(“Dát.vzniku”).replace(“.”,“/”)))<DateTime Select p).ToArray.CopyToDataTable

[Brano (Branislav)]

Hi Vivek,

thank you for you advice, but if I use it I have validations error in assign:

any idea?

Thank you.

Best regards

BM

[Brano (Branislav)]

General problem is how can I change general format in data table(excel)??I try create new column and create it during for each row, but I use two ways how can I do it but result is still same.1st format cells to date type and insert value(str) to value (DT) or only Str.replace(“.”,“/”).Data in this cells have different format???10.11.2018
24/09/2018
14/08/2018
8.9.2018
7.2.2018

[Vivek_Arunagiri]

Use this

(From p In ExtractDataTable.Select() Where Convert.ToDateTime((p.Item(“Dát.vzniku”)))<DateTime.replace(“.”,“/”) Select p).ToArray.CopyToDataTable

We used replace in wrong place.

[Brano (Branislav)]

Hi Vivek,
replace we use in right place on left site.I use this select without replace.I must find way, how replace data in excel. I wrote about it above, but now I find way how can I fix it.This isn’t UIpath problem but problem with excel.I add new column behind data array and I use For each row, where I split string and in next step get together.Part(1)+“/”+Part(0)+“/”+Part(2).Now , select works perfect.Thank you for your time and help