Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 February 2024

Top 3 Topics with Most Views

Ui Path Studio Issue made by @Progressive_RA_DC with 54 views.

LINQ - Split data made by @Vandekamp with 54 views.

HTTP request with XML input made by @Povilas_Jonikas with 44 views.

Top 3 Topics with Most Replies

Generate data table with row index of duplicate rows in table and number of duplicates in table made by @E.T.S with 21 replies.

Regex code to get the ISIN number made by @Priyesh_Shetty with 15 replies.

Recent Date made by @0bb4628e217fd43ac86ac9294 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@ppr made 23 posts!

@rlgandu made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Json limitation

Perfect so the topic can be closed Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

This post made by @RobotReader received 1 likes!

How to use LINQ for Processing an Array?

This video may be useful: Using LINQ with Array in UiPath

This post made by @mkankatala received 1 likes!

Regex for Date- Uipath activity

Hi @Anjali_Rani Check the below one, \d+\s*\w+\s*\d+ Check the below image for better understanding, [image]

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 2 likes!

AsEnumerable Data Table - Count rows

hey @Ruy_Codo dtTransactionData.AsEnumerable().Count(Function(row) row("Ref. to other vendor").ToString.Length = 5).ToString() dtTransactionData.AsEnumerable().Count(Function(row) row("Ref. to other vendor").ToString.StartsWith("9")).ToString() dtTransactionData.AsEnumerable().Count(Function(row) Not row("Ref. to other vendor").ToString.StartsWith("9") AndAlso row("Ref. to other vendor").ToString.Length <> 5).ToString()

This solution provided by @Yoichi received 1 likes!

Remove the character if that starts with the value of particular column in excel

Hi, Can you try the following sample? [image] dt.AsEnumerable.Where(Function(r) r("Ref_ID").ToString.StartsWith("9")).ToList().ForEach(Sub (r) r("Ref_ID")=r("Ref_ID").ToString.SubString(1) End Sub ) Sample20240208-1.zip (11.5 KB) Regards,

This solution provided by @postwick received 1 likes!

Time difference queue activities

No, Reference isn’t part of SpecificContent. It’s part of the queue item object itself. You get it with yourQueueItemVar.Reference For any variable you can always just type it into an expression box and then type a . at the end to see all the properties. [image] But the real point to the Reference is you can use it for filtering with Get Transaction or Get Queue Items, and also enforce unique reference on the queue itself (setting in Orchestrator) so that duplicate items cannot be added to t…

---

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.