Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 August 2023

Top 3 Topics with Most Views

Having Error in Data Extraction Scope made by @Mariam_Saeed with 69 views.

How to run a python script in UiPath StudioX made by @Afsal_Baaqir_A with 62 views.

Help me to create regex to only get numbers made by @StevenIsRobotOnline with 61 views.

Top 3 Topics with Most Replies

Help me to create regex to only get numbers made by @StevenIsRobotOnline with 35 replies.

Having Error in Data Extraction Scope made by @Mariam_Saeed with 33 replies.

Excel query- if value have more than 100 then pass or fail made by @Jeeru_venkat_Rao with 29 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@mkankatala made 47 posts!

@rlgandu made 45 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 3 likes!

How to load Excel data into a DataTable and calculate row and column sums?

Hi @ram_pv dt.AsEnumerable.Sum(Function(r) r.ItemArray.Sum(Function(a) cint(a.ToString))) gives Total Sum of rows the datatable dt.Columns.Cast(of DataColumn).Select(Function(c) dt.AsEnumerable.Sum(Function(r) Cint(r(c.ToString)))).Toarray Gives the columns count of datatable cheers.

This post made by @anthonyjr received 3 likes!

Regex Alphanumeric and Certain Special Characters

All the solutions presented were working but this kind of solution is what I’m looking for, more dynamic and flexible. Thanks miss @sasi_poosarla and also to sir @tazunnisa.badavide , @rlgandu , @mkankatala and @lrtetala

This post made by @vinjam_likitha received 3 likes!

I need to filter multiple excel columns data

Thank you all for the solutions

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

【質問】ActionCenter タスクの割り当て方法について

Hi @jin.ota You can assign to other If you have admin access - All users, that have the required permissions for the specific folder, can be assigned an action. To assign an Action to another user: Make sure you are in the Manage Actions view. On the Unassigned tab, select the More options [image] menu for the desired action. Select Assign to user. The Assign Action window opens. Select a user from the drop-down list. Hope it helps!!

This solution provided by @rlgandu received 1 likes!

Extract the date

@NA_AN Assign firstDayOfPrevMonth = Now.AddMonths(-1).AddDays(-Now.Day + 1) Assign lastDayOfPrevMonth = Now.AddDays(-Now.Day).AddTicks(-1)

This solution provided by @Yoichi received 1 likes!

DataRow[]変数に値が入っているか判定

地名_1はデータテーブルを結合した際に自動生成される列名です。 （同一データテーブル内に同じ列名が存在できないので） 以下Windowsプロジェクト版ですので一度お試しください。 Sample20230808-5CS.zip (3.8 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.