Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 November 2021

Top 3 Topics with Most Views

Can't use studio says no robot configured for current user made by @charliefik with 46 views.

Adding DataRow in between of datatable -- Help made by @Anjali_Rani with 39 views.

Create an empty excel made by @tilarapiyush with 38 views.

Top 3 Topics with Most Replies

Can't use studio says no robot configured for current user made by @charliefik with 19 replies.

メモ帳出力の操作を共通化したさせたい。 made by @natumikann with 14 replies.

Adding DataRow in between of datatable -- Help made by @Anjali_Rani with 9 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 15 posts!

@Yoichi made 13 posts!

@charliefik made 10 posts!

Top 3 Most Liked Posts

This post made by @rahulsharma received 2 likes!

Count Number of Occurrences of Each Word in Column

Use a for loop and inside that you can count the occurrence of each row element in loop in a specific column. dtYourDatatable.AsEnumerable().Count(Function(row) row("strYourColumnName").ToString.Equals(row.toString))

This post made by @wasea received 1 likes!

UiPath Community Survey - share your views with us!

(Anonymus) Done.

This post made by @Boopathi.M received 1 likes!

Format dates in Google sheet while writing through Datatable

hi @Sujit_Pavaskar Glad the attached xaml works for you. Modified the code to write empty date column as string.empty in column or you can give any default value you want. UpdateDateTimeValue_1.zip (9.0 KB) If it helped you, you can mark this thread as solution. Thanks,

Top 3 Most Liked Solutions

This solution provided by @rahulsharma received 2 likes!

Count Number of Occurrences of Each Word in Column

Use a for loop and inside that you can count the occurrence of each row element in loop in a specific column. dtYourDatatable.AsEnumerable().Count(Function(row) row("strYourColumnName").ToString.Equals(row.toString))

This solution provided by @Boopathi.M received 1 likes!

Format dates in Google sheet while writing through Datatable

hi @Sujit_Pavaskar Glad the attached xaml works for you. Modified the code to write empty date column as string.empty in column or you can give any default value you want. UpdateDateTimeValue_1.zip (9.0 KB) If it helped you, you can mark this thread as solution. Thanks,

This solution provided by @Yoichi received 1 likes!

Extract string with new line using regex

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=MUC\d+\s+)\d+").Value 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.