Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 July 2021

Top 3 Topics with Most Views

How to get the files from a folder in the same order it is saved? made by @Vignesh_Sahoo with 35 views.

How to Sum Negative and postive values in a single column in Excel made by @surya_teja.k with 30 views.

Internet explorer : “Open Browser: Cannot communicate with Internet Explorer browser” made by @annaa801252 with 29 views.

Top 3 Topics with Most Replies

How to Sum Negative and postive values in a single column in Excel made by @surya_teja.k with 11 replies.

ERROR: 1420, Message - 'Cannot acquire a license.' made by @atoi with 8 replies.

Timeout reached and Unlicensed License status made by @Aleksey_M with 8 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 10 posts!

@surya_teja.k made 6 posts!

@NIVED_NAMBIAR made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Issue in data filtering

Give a try on: Assign activity leftside: dtFiltered | DataType:DataTable Right side: (From d in YuurDataTableVar.AsEnumerable let acmn = d(yourColNameOrIndex).toString.Trim Where acmn.length = 8 Or acmn.length = 10 Select r=d).CopyToDataTable handling empty filter result can be done with following patterns: [grafik]

This post made by @kumar.varun2 received 2 likes!

Combining while and for each

Hi @ayub_z How about this [image] before for each data row loop initialize the counter as 0

This post made by @ppr received 1 likes!

Issue in data filtering

Currently we are working on rolling out a tutorial series on learning LINQ. Have a look on the first tutorials here: we suggest to start with learning the basics on List/Array base. With some more practice doing LINQ on datatables will be easier and more sucessfully.

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Issue in data filtering

Give a try on: Assign activity leftside: dtFiltered | DataType:DataTable Right side: (From d in YuurDataTableVar.AsEnumerable let acmn = d(yourColNameOrIndex).toString.Trim Where acmn.length = 8 Or acmn.length = 10 Select r=d).CopyToDataTable handling empty filter result can be done with following patterns: [grafik]

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

Combining while and for each

Hi @ayub_z How about this [image] before for each data row loop initialize the counter as 0

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

How to Sum Negative and postive values in a single column in Excel

@surya_teja.k try this dt.AsEnumerable.Sum(Function (x) If(x(1).ToString.Replace(" ","").IsNumeric, CDbl(x(1).ToString.Replace(" ", "")), 0 ))

---

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.