Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 November 2022

Top 3 Topics with Most Views

Read PDF FILE and get text made by @Kuldeep_Pandey with 47 views.

How can i compare two excel files? made by @aparna30 with 43 views.

How to get the numer out of this picture made by @alirida.alhalass with 38 views.

Top 3 Topics with Most Replies

Read PDF FILE and get text made by @Kuldeep_Pandey with 24 replies.

[StudioX]から[Studio]へのプロファイル切り替え方法 made by @yuai with 19 replies.

How to filter duplicate emails made by @Milo_Soderberg with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 82 posts!

@Anil_G made 53 posts!

@Yoichi made 48 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Insert a character in a string

Hi, Can you try the following expression? Double.Parse(yourString).ToString("#.00") [image] Regards,

This post made by @Yoichi received 2 likes!

File missing in nuget file after publish

HI, The above image shows RestSharp106.6.10 or higher is missing. Unfortunately, in some version of UiPath installer lacks necessary RestSharp package in the installer. So we need to add it and its dependcies package to Orchestrator or machine which robot works. Or as another lazy approach, if it works dev environment, can you try to copy all the folders %USERPROFILE%.nuget\packages to same place of machine which robot works. Regards,

This post made by @Tejaa received 1 likes!

Monthly Forum rewards - October 2022

Congratulations all! Filled out the form, don’t think I am eligible for the certification discount voucher but still would love to receive one. Even for the associate exam.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Insert a character in a string

Hi, Can you try the following expression? Double.Parse(yourString).ToString("#.00") [image] Regards,

This solution provided by @Yoichi received 1 likes!

Execute an action if len of a string in browser is more than 1

Hi, I think we can use GetText activity with proper selector. Probably we can use colName attribute. So can you try to use UiExplorer then indicate target cell? Or, as another approach, it’s also good to use DataScraping. Regards,

This solution provided by @Yoichi received 1 likes!

How to split excel row

HI, Hope the following sample helps you. LINQ case [image] dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r("Employee ID").ToString,System.Text.RegularExpressions.Regex.Match(r("Employee ID").ToString,"\S+$").Value},False)).CopyToDataTable() ForEachRow case [image] System.Text.RegularExpressions.Regex.Match(CurrentRow("Employee ID").ToString,"\S+$").Value Sample20221111-3.zip (10.4 KB) 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.