Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 September 2023

Top 3 Topics with Most Views

Regarding excel calculation made by @ramshiva_reddy with 37 views.

Need RegEx help please made by @chrystine.h with 34 views.

I cannot go beyond the For Each DataTable activity in the REF template made by @tolgademir with 33 views.

Top 3 Topics with Most Replies

Issue with Shift_F5 on As-400 Application? made by @Salman_Faries with 9 replies.

Downgrading Studio made by @J_Crosby with 6 replies.

I cannot go beyond the For Each DataTable activity in the REF template made by @tolgademir with 6 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 13 posts!

@Anil_G made 13 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 3 likes!

Need RegEx help please

Hi There is a knowledge base in UiPath forum on all functionalities of datatable Have a view on this for more insights For your scenario This is with normal IsNullOrEmpty method dt1 = dt1.AsEnumerable().Where(Function(a) NOT String.IsNullOrEmpty(a(“Email”).ToString.Trim) ).CopyToDatatable() If you want to remove with the Regex dt1 = dt1.AsEnumerable().Where(Function(a) NOT System.Text.RegularExpressions.Regex.IsMatch(a(“Email”).ToString.Trim, “[\W|\w]").CopyToDatatable() Hope this helps …

This post made by @Chirag12 received 2 likes!

Monthly Forum Rewards - August 2023

Thank you @Anil_G and @Vikas_M , You both have been helping me a lot lately Well deserved!

This post made by @Sudarshana_Sharma_P received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Awesome. I like all the smiley’s. Good effort to enhance the conversations

Top 3 Most Liked Solutions

This solution provided by @neha.upase received 1 likes!

Need RegEx help please

Use an “Assign” activity to create a new data table that contains only the rows you want to keep. Let’s call this new data table filteredDt. In the “Value” field of the “Assign” activity, use LINQ to filter the rows of dt1 based on the condition that the “Email” column is not null or whitespace. You can use the Where method with a lambda expression to achieve this. Here’s the code for the “Value” field: filteredDt = dt1.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Emai…

This solution provided by @Anil_G received 1 likes!

If activity - Message Box not popping up after user input

@OGunnarsson Welcome to the community The problem is your while condition The if condition is not placed inside the while loop…so the while loop will end only when you give the correct answer…hence the if condition is executing only correct one… Try to move your if condition into the while loop then for each loop or guess you will get the message pop up as needed Cheers

---

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.