Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 December 2021

Top 3 Topics with Most Views

Uipath Studio : An error occurred during the activation of a particular registration made by @charan.singh with 63 views.

Split a string without a delimiter made by @Gopalakrishnan_K with 50 views.

Array To String made by @pavithra_pavi with 44 views.

Top 3 Topics with Most Replies

Want to be able to specify one of a group of buttons made by @ruiang with 12 replies.

SNOW + HTTP Get Request + Unable to open downloaded Excel & Pdf files made by @Sairam_RPA with 11 replies.

Error occurred when using the DownloadPackage api made by @1111141 with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 28 posts!

@kirankumar.mahanthi1 made 22 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 8 likes!

Array To String

Array To String Hello to my UiPath Community. Hope you all are doing great!!!. I have been asked a lot by my fellow connections here or my other social media that how we can convert Arrays into Strings. So, I thought why not make a video on this, and share it across all my social media platform to reach all those people who want answers to this question. Here is the video link, Check out and also get the source code

This post made by @jeevith received 7 likes!

Split a string without a delimiter

Hi @Gopalakrishnan_K, String[] YourVariable = System.Text.RegularExpressions.Regex.Split("OtherSupplierLogisticsDesign", "(?<!^)(?=[A-Z])"); YourVariable is an array type containing string items. Later you can poll the array like so YourVariable(0).ToString.Trim resulting in "Other" YourVariable(1).ToString.Trim resulting in "Supplier" YourVariable(2).ToString.Trim resulting in "Logistics" YourVariable(3).ToString.Trim resulting in "Design" So each of the purple piped lines will be place…

This post made by @Masli received 4 likes!

New Training! UiPath Integration Service

New course release: UiPath Integration Service We proudly present this training which will equip you with the skills and knowledge needed to automate complex enterprise processes through RPA and UI automation, together with API automation from app integrations. Duration: 1 hour Audience: RPA Developers familiar with UiPath RPA development capabilities Objectives: Expand the skillset with API automation of third-party apps such as: Outlook, OneDrive, ServiceNow, Salesforce,…

Top 3 Most Liked Solutions

This solution provided by @yoshimura.tomoko received 1 likes!

画面にセットしたパスワードを確認したい

先日はありがとうございました。 パスワードについては、文字列一致チェックではなく 入力パスワード=画面セットしたパスワード桁数のチェックで構わないと上長確認が 取れましたので、そちらで実施してまいります。 今後ともよろしくお願いいたします

This solution provided by @kirankumar.mahanthi1 received 1 likes!

File is read only and cannot be overwritten

Hi, Some how execute macro making xlsm file to read only mode. Did you already enable all option in the macro settings in the excel application scope. And also please un check the save excel option if you are just reading the visible sheet names from xlsm file so un necessarily it will not try to save xlsm for each and every action. Please try the above option and let us know. If you still not able to resolve the issue. If possible please share us the macro code you are trying run in that xl…

This solution provided by @Yoichi received 1 likes!

Filter Date from datatable after scraping from web

Hi, Can you try the following expression? ExtractDataTable = ExtractDataTable.AsEnumerable.Where(Function(r) DateTime.Parse(r("PRDDATE").ToString)>=New DateTime(2021,12,1) AndAlso DateTime.Parse(r("PRDDATE").ToString)<=New DateTime(2021,12,10)).CopyToDataTable Note: If there is invalid date string/character (including empty) in PRDDATE column, the aboce will fails. Regards,

---

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.