Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 November 2022

Top 3 Topics with Most Views

Removing validation error made by @lq_c with 40 views.

Github UIPath App not working made by @EchoS with 31 views.

How to open logs from execution_log_data made by @RPA_Canada with 30 views.

Top 3 Topics with Most Replies

Can't access for each json children after deserializing made by @pink_unicorn_waifu with 17 replies.

DataTable Group By and Sum made by @huang.kaijin with 10 replies.

Unable to upload sheets in uipath made by @Cuberoot with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 33 posts!

@pink_unicorn_waifu made 7 posts!

@Justine made 6 posts!

Top 3 Most Liked Posts

This post made by @neil.obrien received 1 likes!

Extract Table Data fails and causes Studio to freeze

Hello Maciej , Packages look like this [image] I have worked around the error by copying an Extract Table activity and then using a click to get the selector and then updating the Extract Table activity with the selector from the click.

This post made by @neil.obrien received 1 likes!

Extract Table Data fails and causes Studio to freeze

Maciej, You are right! Updated to current versions and the problem disappeared. Thank you!! [image]

This post made by @RajKumar_DC received 1 likes!

How to open logs from execution_log_data

Hi @RPA_Canada, Use Ctrl+L

Top 3 Most Liked Solutions

This solution provided by @RajKumar_DC received 1 likes!

How to open logs from execution_log_data

Hi @RPA_Canada, Use Ctrl+L

This solution provided by @Anil_G received 1 likes!

Is there a way to extract the account no values(excluding special characters that are not numeric or alphabets)?

Hi @Justine “1.12345678/2.35548674” this is the string that is being passed in the assign if you want to split what is there in excel then read the excel into datatable…run a for each loop and pass currentrow(“Youraccountnumbercolumnname”).Tostring then it will get the account numbers eg: System.Text.RegularExpressions.Regex.Matches(currentrow(“Youraccountnumbercolumnname”).Tostring,“\d+.\d+”) Note: Do this inside for each row in datatable loop. Keep assign and the for each(already created)…

---

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.