Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 May 2021

Top 3 Topics with Most Views

How to remove leading zeros from data table column made by @roysupriya21 with 37 views.

Get queue items pushed in last 1 Hour made by @Sahil_Garg1 with 35 views.

ワークフローを終了と強制終了の違い made by @196006 with 34 views.

Top 3 Topics with Most Replies

Read Range : Couldnt read range [Excel] made by @AS07 with 14 replies.

Open browser activity not working made by @ad2000 with 14 replies.

How to remove leading zeros from data table column made by @roysupriya21 with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 14 posts!

@postwick made 10 posts!

@NIVED_NAMBIAR made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Formating a variable

@Jose_Pedro_Mendes Welcome to the forum PadLeft will help us: [grafik]

This post made by @postwick received 2 likes!

Get queue items pushed in last 1 Hour

Get all the Queue Items and then when processing, check if it was created in the last hour. If not, skip it.

This post made by @ppr received 2 likes!

Linq query to filter using between operator in Datatable

give a try on: [grafik] [grafik] (From x In {"02"} Let dl = dtData.AsEnumerable.toList Let fi = dl.FindIndex(Function (d) d(0).toString.Equals(x)) Let li = dl.FindLastIndex(Function (d) d(0).toString.Equals(x)) From r In dtData.AsEnumerable.Skip(fi).Take(li-fi + 1) Select r).toList then branch: drResult.CopyToDataTable

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Extract the last word using regex

Hi, Can you try the following pattern? \S+$ Regards,

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to remove leading zeros from data table column

Hi @roysupriya21 for this we had to do some modifications in same code as i told above Modified code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Depost”)= If(row(“Depost”).ToString.Length<=6,CInt(row(“Depost”).ToString),row(“Depost”))) Try this and let me know if it works Regards, Nived N Happy Automation

This solution provided by @prasath_S received 1 likes!

How to copy selected rows from one excel to another empty excel file

@WASEEM_KHAN if you can mark this as solution, for others it will be helpful. [image] Thanks

---

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.