Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 March 2022

Top 3 Topics with Most Views

Celebrating 5️⃣ anniversary with UiPath Forum made by @lakshman with 56 views.

Extract certain string between "|" made by @Ionut_Frincu with 49 views.

Read multiple invoice format made by @mayachoy with 42 views.

Top 3 Topics with Most Replies

How to run "Start Job" for designated Robot made by @Lori with 17 replies.

Celebrating 5️⃣ anniversary with UiPath Forum made by @lakshman with 14 replies.

Extract certain string between "|" made by @Ionut_Frincu with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 47 posts!

@Palaniyappan made 17 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 16 likes!

Celebrating anniversary with UiPath Forum

Hey Guys, As the cake near my name says, today is my year anniversary since I joined the UiPath Forum [Screenshot_20220309-093859] I have learnt a lot from forum during these years especially from @ppr (Linq query expert), @Yoichi (Regex expert), @StefanSchnell (SAP automation expert), @balupad14 (Excel automation expert) and also made a lot of friends like @Lahiru.Fernando, @Palaniyappan, @nerlichman, @Divyashreem, @prasath_S etc… I…

This post made by @lakshman received 3 likes!

Celebrating anniversary with UiPath Forum

@prasath_S @Yoichi @nikhil.girish Thanks to you as well for your continuous support to the UiPath community. Keep up the good work

This post made by @lakshman received 2 likes!

Celebrating anniversary with UiPath Forum

Thanks to you @Gokul001 & @Sudharsan_Ka as well for your continuous support to the UiPath community. Keep up the good work.

Top 3 Most Liked Solutions

This solution provided by @Sadmim_Hossain1 received 2 likes!

Delete rows excel (loop)

Hello, I hope this works for you DeleteRowsExcelLoop.xaml (13.2 KB)

This solution provided by @Gokul001 received 1 likes!

C# or vba?

Hi @ankur.kaushik Welcome to community Have a look on the thread Regards Gokul

This solution provided by @ashwin.ashok received 1 likes!

How to check if one column is equal another colum in excel and add a new column

Hi @siteltower , Could you try and see if the logic performs the operation as expected? (From row In dt_masterData.AsEnumerable() Let upd = dt_updateData.AsEnumerable().Where(Function(w) w("ID").ToString.Trim.Equals(row("ID").ToString)).ToArray() Let ra = New Object(){row("ID"),row("Service Type"),row("Assets SN"), upd.First().Item("Status"),upd.First().Item("Issue"),row("Name"),row("Project")} Select dt_result.Rows.add(ra)).CopyToDataTable() CheckIfColumnsAreSame.xaml (7.8 KB) Kind 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.