Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 April 2023

Top 3 Topics with Most Views

I want to read specific text from pdf . How should I read it made by @Bhushan_Nagaonkar with 63 views.

How to replace alternate value of Dictionary from the List made by @siddhi.rani with 50 views.

Change Name of Environment made by @Volker_Hofheinz1 with 47 views.

Top 3 Topics with Most Replies

I want to read specific text from pdf . How should I read it made by @Bhushan_Nagaonkar with 22 replies.

Count data rows including the NextLinkSelector made by @ANGE with 14 replies.

Getting the value of a particular column from datatable without using for each row made by @Kunal_Jain with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@Yoichi made 28 posts!

@supermanPunch made 21 posts!

Top 3 Most Liked Posts

This post made by @vishal.kp received 2 likes!

Remove duplicates in excel using time

Hi @Praveen_Vs , -Keep preserve formatting true while reading the Excel Try the following: (From row In dt.AsEnumerable() Group By policy = row("Policy").ToString() Into policyGroup = Group Let latestEntry = policyGroup.OrderByDescending(Function(r) DateTime.Parse(r("Time").ToString())).FirstOrDefault() Select latestEntry).OrderBy(Function(r) DateTime.Parse(r("Time").ToString())).CopyToDataTable() Regards,

This post made by @Jithesh_R received 2 likes!

Remove duplicates in excel using time

Hey @Praveen_Vs , To do this you can follow these steps. 1.Initially Read your Input Using "Read range workbook " activity 2. Sort the input datatable in descending order (Using “Time” Column) 3. Now all the recent timings will come first . 4. Then you can group the data By taking the first value(That is ignoring the duplicate values) Please find the attached workflow RemoveDuplicateUsingTime.zip (1.7 KB) Output: [image] Regards,

This post made by @balupad14 received 2 likes!

Unable to install Bala Reva easy excel packages

Hi All, Now you have a new version 23.0.0. It is compatibility with windows legacy and windows. Thank you Balamurugan.S

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 2 likes!

Remove duplicates in excel using time

Hi @Praveen_Vs , -Keep preserve formatting true while reading the Excel Try the following: (From row In dt.AsEnumerable() Group By policy = row("Policy").ToString() Into policyGroup = Group Let latestEntry = policyGroup.OrderByDescending(Function(r) DateTime.Parse(r("Time").ToString())).FirstOrDefault() Select latestEntry).OrderBy(Function(r) DateTime.Parse(r("Time").ToString())).CopyToDataTable() Regards,

This solution provided by @Jithesh_R received 2 likes!

Preencher um dataTable atraves de uma string com valores separados por virgulas

@devrpa746 , Please check this workflow StringTest.zip (2.1 KB) Output : [image] Regards,

This solution provided by @supermanPunch received 2 likes!

I want to read specific text from pdf . How should I read it

Hi @Bhushan_Nagaonkar , We will not be able to provide a proper regex if the Sample data format is not provided, However check the below regex : (?<=social security number.*\s*)[\d-]+ [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.