Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 September 2022

Top 3 Topics with Most Views

Unable to fetch table data from web application made by @sagarjb with 41 views.

Dynamic file name of excel file made by @Agnes_Castro_Salvador with 40 views.

Remove row from a particular string from data Table made by @taruna.mehra with 34 views.

Top 3 Topics with Most Replies

Remove row from a particular string from data Table made by @taruna.mehra with 25 replies.

Read huge excel range into a data table made by @A_Learner with 22 replies.

Could not find the user-interface (UI) element for this action - Unattended robot made by @ankur.agarawal with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 37 posts!

@Yoichi made 25 posts!

@raja.arslankhan made 23 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 4 likes!

Monthly Forum rewards - August 2022

@loginerror Thank you so much an Congratulations Everyone. I will try to give community my best.

This post made by @Veera_Raj received 3 likes!

Monthly Forum rewards - August 2022

congratulations to everyone

This post made by @StefanSchnell received 3 likes!

Monthly Forum rewards - August 2022

Congratulations to all the winners and thank you for your effort.

Top 3 Most Liked Solutions

This solution provided by @grkiran2 received 1 likes!

Need Help to understand the Code

The state is in this format: If(<condition> , <Value when condition is True> , <Value when condition is False>) In you case IF evaluates the condition CBool(in_Config("SomeImput1").ToString). if True, returns value for in_Config(“Input2”).Tostring if False, returns value for in_config(in_config(“Input3”).Tostring+“_”+in_config(“input4”).tostring+“_AppName”).ToString

This solution provided by @Gokul001 received 1 likes!

Extracting substring from a string

Hi @gokul1904 How about this expression? System.Text.RegularExpressions.Regex.Match(YourString,"(WEF\S\d+)(?=\s)|(WEF\S\d+)(?=[a-z])").Tostring [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

Issue on ascending order on table

HI, Thanks, the following will work. Can you try this? dt.AsEnumerable.Where(Function(r) Double.Parse(r("Discount").ToString)>10).OrderBy(Function(r) Double.Parse(r("Discount").ToString)).CopyToDataTable() Regards,

---

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.