Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 July 2021

Top 3 Topics with Most Views

Read file by regex? made by @fairymemay with 42 views.

Save a file in count form made by @Guilherme_Silva with 36 views.

Data Loss- While writing data in Excel made by @Harshad_Jadhav with 35 views.

Top 3 Topics with Most Replies

Save a file in count form made by @Guilherme_Silva with 24 replies.

Drop-Down Field - Click made by @PaulMo with 14 replies.

Bot is not sending the mail made by @sneha_arbole with 11 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@ermanoj3101 made 28 posts!

@hsendel made 13 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Convert String()() to String() In Vb.Net

Hi, Can you try the following expression? arrStr = arrArrStr.SelectMany(Function(a) a).ToArray Note: arrStr is String[] type. arrArrStr is String[][] type. Regards,

This post made by @ppr received 3 likes!

Column Transpose with Condition on its Cells' Values

@hsendel we can do it dynamicly with the help of groupBy, dictionary and LINQ Variables: [grafik] Grouping the data by the the first two letters into a dictionary: [grafik] retrieving the max length for the longest group: [grafik] Preparing the result datatable columnstructure: [grafik] Build datatable with first column (ColName: Key), then we do add the other columns: [grafik] Finaly we use following LINQ for populating the target DataTable: [grafik] LINQ iterates over the Group…

This post made by @StefanSchnell received 2 likes!

A new UI Automation input method: the ChromiumAPI - highlights

@gheorghestan Sounds excellent Gheorghe.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Convert String()() to String() In Vb.Net

Hi, Can you try the following expression? arrStr = arrArrStr.SelectMany(Function(a) a).ToArray Note: arrStr is String[] type. arrArrStr is String[][] type. Regards,

This solution provided by @ppr received 3 likes!

Column Transpose with Condition on its Cells' Values

@hsendel we can do it dynamicly with the help of groupBy, dictionary and LINQ Variables: [grafik] Grouping the data by the the first two letters into a dictionary: [grafik] retrieving the max length for the longest group: [grafik] Preparing the result datatable columnstructure: [grafik] Build datatable with first column (ColName: Key), then we do add the other columns: [grafik] Finaly we use following LINQ for populating the target DataTable: [grafik] LINQ iterates over the Group…

This solution provided by @Palaniyappan received 2 likes!

Log Message function

Hi @SH_94 Logging is important for three reasons Logs writes the specified diagnostic message at the specified level. Say for example you are using excel activities to read a excel file and you are keeping a log message activity right after the excel activities mentioning as “EXCEL FILE IS READ SUCCESSFULLY” now when bot is executed and if you want to validate whether excel file is read successfully or not, you can check the output panel or the execution log files whether the LOG MESSAGE AC…

---

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.