Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 March 2024

Top 3 Topics with Most Views

Copy Column data from Column J to column A made by @vignesh.maruthappan with 54 views.

Calendar Date Web Browser made by @Jackson_Hew with 48 views.

Read data by use header (column A) made by @Stef_99 with 45 views.

Top 3 Topics with Most Replies

String convertTo DateTime made by @Hari_Krishnan2 with 20 replies.

How to extract group of data in payer column based on company code of duplicate values made by @Jyothi1 with 16 replies.

HELP！I can't find Uipath.pdf.activities package made by @pxx_xd with 13 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 26 posts!

@Anil_G made 20 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @aks_test received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Dear Team, Thank you for presenting Challenge #2! Below are three different methods to find the multiplication of three numbers: Find the project file and documentation in the attached zip. HypAuto_Challenge2_Mul3Num.zip (8.4 KB)

This post made by @gangagiridatta received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Dear @pradeep_ch , @pathrudu , @AutomationX_by_Kiran, and @loredana_ifrim, Thank you for the challenge. Attached is the zip file containing the solution. Challenge2_Multiply_ThreeNumbers.zip (8.6 KB)

This post made by @shwetu131 received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Hello @AutomationX_by_Kiran , @pradeep_ch Challenge2_Multiplication_Of_Three_Numbers.zip (8.2 KB) Thank you for Challenge #2! Please find the Multiplication Of Three Numbers project zip folder file.

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

How to extract group of data in payer column based on company code of duplicate values

Hi @Jyothi1 => Read Range Workbook [image] Output → dt => Use below syntax in Assign: resultDt = (From row In dt.AsEnumerable() Group row By CompanyCode = row.Field(Of Double)("Company") Into Group Select result = New Object() {CompanyCode, String.Join(",", Group.Select(Function(r) r.Field(Of String)("Payer")))}) _ .Select(Function(x) dt.Clone().Rows.Add(x)).CopyToDataTable() => Write Range Workbook resultDt. [image] [image] data.xlsx (10…

This solution provided by @mkankatala received 1 likes!

Filter the Dates from Column

Hi @dheerandra.vishwakarma → Use the Read range workbook activity to read the excel and store in a datatable called dt_Input. → Then take an assign activity, and you can use LINQ Expression, - Assign -> dt_Output = (From row In dt_Input.AsEnumerable() Where System.Text.RegularExpressions.Regex.IsMatch(row("Date").ToString(), "\d+/\d+/\d+") Select row).CopyToDataTable() → Then use the Write range workbook activity to write the dt_Output to …

This solution provided by @noufalahammed received 1 likes!

Help with RegEx on text extracted from a PDF

RegEx.xaml (9.2 KB) Please refer the attached workflow Below is the result of the workflow [image]

---

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.