Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 April 2023

Top 3 Topics with Most Views

Compare column values from two different excel sheets and highlight the matching column values with green made by @dutta.marina with 60 views.

Split excel record made by @pravin_bindage with 59 views.

Text extraction based on Regex made by @Midhila_Gurram with 52 views.

Top 3 Topics with Most Replies

Compare column values from two different excel sheets and highlight the matching column values with green made by @dutta.marina with 21 replies.

Split excel record made by @pravin_bindage with 14 replies.

Powershell呼び出し made by @windntmd with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 26 posts!

@Yoichi made 18 posts!

@Srini84 made 17 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

Date conversion topic

Hey @duaine.b , Try this DateTime.ParseExact("Thu 10 Nov 2022", "ddd dd MMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Output : [image] Note : Output Value is of type String Regards,

This post made by @Srini84 received 2 likes!

DATASET VARIABLE

Hi @Aki1111 Dim selectedData As DataTable = myDataset.Tables("myTable").DefaultView.ToTable(False, columnsToSelect) Try in above way Hope this may help you Thanks, Srini

This post made by @Yoichi received 2 likes!

Need Regex Range Number Excel

Hi, Can you try to modify your expression in the InvokeCode activity as the following? row("Extracted Data") = System.Text.RegularExpressions.Regex.Match(row(0).ToString,“([A-Z]{4})([0-9]{6})([0-9]{1})”).Value.Insert(10,"-").Insert(4," ") The following is result of the above. [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

Date conversion topic

Hey @duaine.b , Try this DateTime.ParseExact("Thu 10 Nov 2022", "ddd dd MMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Output : [image] Note : Output Value is of type String Regards,

This solution provided by @Yoichi received 2 likes!

Need Regex Range Number Excel

Hi, Can you try to modify your expression in the InvokeCode activity as the following? row("Extracted Data") = System.Text.RegularExpressions.Regex.Match(row(0).ToString,“([A-Z]{4})([0-9]{6})([0-9]{1})”).Value.Insert(10,"-").Insert(4," ") The following is result of the above. [image] Regards,

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

Custom Sort Multiple Columns

Hi @Md_Hidayat , Refer to the following thread, it explains the sorting of data table based on multiple columns. 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.