Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 February 2022

Top 3 Topics with Most Views

Delete Dup by condition? made by @fairymemay with 75 views.

Http Post Request Query made by @supu123 with 72 views.

GSuite - Send mail - Changing attachment type and name made by @Eduard with 42 views.

Top 3 Topics with Most Replies

Problem with Date Filtering a DataTable made by @ieptus with 30 replies.

Excel - Programmatic access to Visual Basic Project is not trusted Exception made by @Aparna_Reddy1 with 19 replies.

Need help in Gsuite! made by @Aditya_Kumar3 with 18 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 38 posts!

@Yogesh1 made 27 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Nam1 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, My name is Nam and I am really excited to learn more about RPA and Uipath.

This post made by @pravin_calvin received 2 likes!

How to update specific values in datatable without using for each row

Hi @111962 assign dtClone=ReadDt.Clone (Vartype datatable) Assign newDt= (From d In ReadDt.AsEnumerable Let u = If(d(1).toString.Equals(“CC”) Or d(1).toString.Equals(“FF”),“0”,d(2).ToString) Select dtClone.Rows.Add(New Object(){d(0),d(1),u,d(3)})).CopyToDataTable Write range the new Dt Regards

This post made by @Hiba_B received 2 likes!

Compare Rate and write value?

Hi @fairymemay ! Here is another suggestion: From_count_to_sum.xaml (9.6 KB) It uses the filter activity to do it, but basically behind the .asenumerable() that suggests @Ramya_K there is a filter in it Let us know if we missed something ! (If you see “missing activities” that means that we are not using the same Studio version. Mine in 21.10)

Top 3 Most Liked Solutions

This solution provided by @pravin_calvin received 2 likes!

How to update specific values in datatable without using for each row

Hi @111962 assign dtClone=ReadDt.Clone (Vartype datatable) Assign newDt= (From d In ReadDt.AsEnumerable Let u = If(d(1).toString.Equals(“CC”) Or d(1).toString.Equals(“FF”),“0”,d(2).ToString) Select dtClone.Rows.Add(New Object(){d(0),d(1),u,d(3)})).CopyToDataTable Write range the new Dt Regards

This solution provided by @Yoichi received 2 likes!

Regex to extract part of the text, Please advice

Hi, Can you try the following LINQ expression? arrString = ExtractDataTable.AsEnumerable.Select(Function(r) System.Text.RegularExpressions.Regex.Match(r(1).ToString,"\D{3}\d{3}(?=\D|$)").Value).ToArray Hope this helps you. Regards,

This solution provided by @Yoichi received 2 likes!

Delete Dup by condition?

HI, How about the following? [img20220218-3] dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("CusName").ToString,r("PlanCode").ToString)).Select(Function(g) g.OrderByDescending(Function(r) Double.Parse(r("FPP").ToString)).First()).CopyToDataTable Sample20220218-1v2.zip (14.9 KB)

---

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.