Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 May 2023

Top 3 Topics with Most Views

UiPath & unattended license made by @Meli_Marco with 58 views.

How to pass transaction data in get transaction data without queues? made by @vnsatyasunil with 55 views.

[InfoSet] - LegacyToWindows Migration # Project Blueprint Overview made by @ppr with 49 views.

Top 3 Topics with Most Replies

How to pass transaction data in get transaction data without queues? made by @vnsatyasunil with 27 replies.

Orchestratorでログが表示されない made by @KITAHARA.HATSUMI with 23 replies.

Compare 2 sheets using 2 column names and get the uncommon data from 2 files made by @kambhampati_manisridhar with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@raja.arslankhan made 35 posts!

@adiijaiin made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

[InfoSet] - LegacyToWindows Migration # Project Blueprint Overview

This post is currently in a preview version and will be further updated in the near future. TL:DR UiPath is based on a code platform provided by Microsoft. This code platform has been evolved by Microsoft and support for older versions will be phased out in the future. This creates the need to migrate existing code projects to a more recent version of the code platform - often referred to as Legacy-to-Windows migration. Migrations can cause uncertainties that should be planned for from the v…

This post made by @Anil_G received 2 likes!

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

This post made by @Anil_G received 2 likes!

Copy list to specific datatable column using linq

@qwerty1 In some or the other way you have to use for each to load the data One thing you can try is to use generate datatable activity and pass the list as string concatenated with new line.this will generate a datatable with one column and all the values as rows String.Join(Environment.NewLine,strlist) Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

This solution provided by @Yoichi received 1 likes!

Rremove the space before the keyword or remove the word from an array of sentences and return the new array

All right. Can you try the following expression? arrRes.Select(Function(s) System.Text.RegularExpressions.Regex.Replace(s,"(?<=\b"+Stringvar1+") (?="+Stringvar2+"\b)| "+Stringvar2+"\b","")).ToArray Regards,

This solution provided by @Yoichi received 1 likes!

Webページからpdfファイルのみをすべてダウンロードする方法

こんにちは ForEachUiElemntを使うか、 https://docs.uipath.com/ja/activities/other/latest/user-guide/n-for-each-ui-element DataScraping(Table Extraction)で表を抽出し それをもとに動的セレクターで順次クリックしていく方法の いずれかが有力かと思います。

---

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.