Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 July 2022

Top 3 Topics with Most Views

Find the fist three and last three character of String made by @Sandhya_Gajare with 48 views.

Calculate Client Security Hash Robot evaluaton fail made by @chandra_mummineni with 37 views.

https://forum.uipath.com/t/457299 made by @Nitya1 with 35 views.

Top 3 Topics with Most Replies

HOW TO CHECK IF STRING STARTS WITH ANY NUMBER made by @saritha with 12 replies.

Not getting expected output from Except function made by @Shikhar_Tandon with 12 replies.

Delete excel file in a certain hour automatically made by @Xheni_Xhensila with 12 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 52 posts!

@Nithinkrishna made 32 posts!

@Rahul_Unnikrishnan made 22 posts!

Top 3 Most Liked Posts

This post made by @pedro.cavadas received 2 likes!

Document Understanding - How to use skills

Hello, in this video we will see how to create custom skills and ready-to-use skills in UiPath Document Understanding, seeing how they work for different types of invoice and analyzing the results before and after retraining. So let’s go! [Learn how to use SKILLS from Document Understanding - @UiPath]

This post made by @Nithinkrishna received 2 likes!

Announcing Studio Web Triggers - Process email attachments when a new email arrives

Looks cool. Will give it a try surely.

This post made by @jack.chan received 2 likes!

How to Increment a three letter string for a variable

use this function UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number) where number is an integer If number = 1 it return “A”, number = 27 return AA if number = 703, it will return “AAA” number = 704…return “AAB” and so on… [image]

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 2 likes!

How to Increment a three letter string for a variable

use this function UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number) where number is an integer If number = 1 it return “A”, number = 27 return AA if number = 703, it will return “AAA” number = 704…return “AAB” and so on… [image]

This solution provided by @kumar.varun2 received 1 likes!

Finding the total sum of 2 columns using LINQ

Hi @Robert_Russell_Monsalud In this case the group by approach can also be used [image] ( From row In dt_Data Group row By k=row("Project Code").ToString.Trim Into grp = Group Select dt_Data.LoadDataRow({k, grp.Sum(Function(gr) CInt(gr("Time"))), grp.Sum(Function(gr) CInt(gr("Cost")))}, True) ).CopyToDataTable XAML for reference TotalSumOf2Columns.xaml (5.6 KB)

This solution provided by @ppr received 1 likes!

Split a dictionary of string

Dictionaries need to have unique Keys Depending on your Case, maybe a Loop over the split value will Work as Well Dict(“Remark”).toString().Split("&"c)

---

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.