I want to perform an automation in a csv file .
The process involves
1.Reading a CSV file from a shared location.
2.The csv file has a column that contains date .I want to filter the data table that is obtained by reading the CSV file in such a manner that all the records that have a date <31/12/1969 are filtered out.
I am trying this using the select method but it is not working
,The syntax for the select method is
datatable.Select(“[column4] > ‘31/12/1969’”)
Check whether ur csv file date and EltoWeekly.Select(“[Column4] > ‘31/12/1969’”) are in same format or not…
In the Above Xaml File, i can just create a variable in array of String and define some date in the list…
And Use some filter operation in That…
It will filter the date.
Sorry @mudit
My above file can check only the date,It will not check the month and Year…
Whether u can join your date like this…“31121969”
Split your date by using “/” and join the date… and Then check…
I think,It will work…
i suggest you create a csv file at your end . Insert dummy data for example name,addreess,dateofbirth ,city
.Insert certain dates then try to read the csv file and filter the data table .Please if you can help with this then it would be very useful
this is the csv file i am talking about. I have to filter this csv file in on the column Exposure To (that contains date) in such a way all records with EXposure To Date as 31/12/1969 or earlier are filtered.So that we remain with only those records where the Exposure To date is greater than 31/12/1969