Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 January 2024

Top 3 Topics with Most Views

Non-Working HOURS (not days) - Is it possible? made by @Mads_Commerou with 43 views.

How to take read range rows count and write cell of 1 to A column made by @sathish_Kumar6 with 39 views.

How to do sumifs by using uipath made by @anjani_priya with 39 views.

Top 3 Topics with Most Replies

Send hot key to browser made by @A_Learner with 18 replies.

How to do sumifs by using uipath made by @anjani_priya with 17 replies.

Comparing Values made by @Pogboom with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@mkankatala made 32 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @AlvinStanescu received 2 likes!

GetAsset() in CodedWorkflows freezing when using all arguments

Hi Lucas, It seems like there is indeed a concurrency issue when the timeout is getting hit. In your case, it would pretty much always get hit, as 1 ms is not enough for this call. If you’d use a higher timeout value the call should work just fine. Thanks, Alvin

This post made by @lucas.stern received 1 likes!

GetAsset() in CodedWorkflows freezing when using all arguments

Hi alvin, unfortanelly the problem occurs independently of the timeout param.

This post made by @Yoichi received 1 likes!

RegEx Based Extractor does not work but same expression works on Matches activity

Hi, The following may work. ((?<=Date:\s+Time:)[\s\S]*?)(?=Signature) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

RegEx Based Extractor does not work but same expression works on Matches activity

Hi, The following may work. ((?<=Date:\s+Time:)[\s\S]*?)(?=Signature) Regards,

This solution provided by @Yoichi received 1 likes!

Excel Segregation help with format

Hi, How about the following sample? Excel Segrigation_v2.zip (17.4 KB) This uses the following Combination library. It’s necessary to add nuget feed in MangePacakge as the following. [image] https://api.nuget.org/v3/index.json Regards,

This solution provided by @ppr received 1 likes!

Excel split based on count

Variables: [grafik] Preps [grafik] Groups = (From d In ReadDT.AsEnumerable Group d By k=d(0).toString.Trim Into grp=Group Select g = grp.ToList()).ToList outerlist: Groups, innerlist: Groupmembers Splittings [grafik] Then: tmpSegment= tmpSegment.Concat(grp).ToList Else: TableList = TableList.Append(tmpSegment.CopyToDataTable).toList Last TableList = TableList.Append(tmpSegment.CopyToDataTable).toList So resulting List(of DataTable) can be used again within a For each e.g. for wri…

---

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.